Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 2 November 2014

Top 135 Informatica Interview Questions


By on 08:45:00

This is overall informatica interview questions, this informatica interview question has been been prepared from experience informatica resource, If you can able to answers those questions you can win any interview in informatica.


1 How do you change parameter when u move it from development to production.
 

2 How does the session recovery work.
 

3 Why use shortcuts(Instead of making copies).
 

4 where is the reject loader .
 

5 How do you use reject loader.
 

6 Do u have to change the reject file b4 using reject loader utility.
 

7 Differences between version 7.x and 8.x.
 

8 Debugger – what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running. 
Top 135 Informatica Interview Questions
Top 135 Informatica Interview Questions


9 Mapplets – can you use an active transformation in a mapplet,
 

10 What are active transformations? Name them.
 

11 Can u use flat files in Mapplets.
 

12 How many transformations can be used in mapplets.
 

13 Can a joiner be used in a mapplet.
 

14 What are active transformations.
 

15 How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
 

16 Global and Local shortcuts. Advantages.
 

17 Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can u use them in the mapping?
 

18 Have you worked with/created Parameter file
 

19 What’s the layout of parameter file (what does a parameter file contain?)?
 

20 Why do u use Mapping Parameter and mapping variable?
 

21 Where do u create/define mapping parameter and mapping variable?
 

22 Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
 

23 Slowly changing dimensions, types and where will you use them
 

24 What are the modules in Power Center
 

25 Filter transformation in the condition one of the data is NULL would the record be dropped.
 

26 Parameter&variable differences
 

27 Reusable transformation & shortcut differences
 

28 Mapplets ( can u use source qyalifier, can u use sequence generator, can u use target)
 

29 Implementation methodology
 

30 Do u have knowledge in ralph kimball methodology
 

31 According to his methodology what all u need before u build a datawarehouse
 

32 How do u recover rows from a failed session
 

33 Sequence generator, when u move from develoment to production how will u reset
 

34 Whats there in global repository
 

35 Repository user profiles
 

36 How do u set a varible in incremental aggregation
 

37 Can u create a flatfile target
 

38 What did u do in source pre load stored procedure
 

39 Scheduling properties,whats the default (sequential)
 

40 In a concurrent batch if a session fails, can u start again from that session
 

41 When u move from devel to prod how will u retain a variable
 

42 Partition, what happens if the specified key range is shorter n longer
 

43 Performance tuning( what u did in performance tuning)
 

44 What are conformed dimensions?
 

45 what are factless facts? And in which scenario will you use such kinds of fact tables.
 

46 can you avoid static cache in the lookup transformation? I mean can you
 

47 disable caching in a lookup transformation?
 

48 what is the meaning of complex transformation?
 

49 in any project how many mappings they will use(minimum)?
 

50 How do u implement unconn. Stored proc. In a mapping?
 

51 Can u access a repository created in previous version of Informatica?
 

52 What happens if the info. Server doesn’t find the session parameter in the parameter file?
 

53 How big was your fact table
 

54 How did you handle performance issues If you have data coming in from multiple 
sources, just walk thru the process of loading it into the target
 

55 How will u convert rows into columns or columns into rows
 

56 What are the steps involved in the migration from older version to newer version of Informatica Server?
 

57 What are the main features of Oracle 8i with context to datawarehouse?
 

58 What are the new features of Power Center 5.0?
 

59 How to run a session, which contains mapplet?
 

60 Differentiate between Load Manager and DTM?
 

61 What are session parameters ? How do u set them?
 

62 When do u use mapping parameters? (In which transformations)
 

63 What is a parameter When and where do u them when does the value will be created
 

64 Desing time, run time. If u don’t create parameter what will happen
 

65 What are variable ports and list two situations when they can be used?
 

66 What are the parts of Informatica Server?
 

67 How does the server recognize the source and target databases. Elaborate on this.
 
68 List the transformation used for the following:
1. Heterogeneous Sources

2. Homogeneous Sources

3. Find the 5 highest paid employees within a dept.

4. Create a Summary table

5. Generate surrogate keys 

69 What is the difference between sequential batch and concurrent batch and which is recommended and why?
 

70 A session S_MAP1 is in Repository A. While running the session error message has displayed
 

71 ‘server hot-ws270 is connect to Repository B ‘. What does it mean?
 

72 How do you do error handling in Informatica?
 

73 How do you implement scheduling in Informatica?
 

74 What is the meaning of up gradation of repository?
 

75 How can you run a session without using server manager?
Consider two cases:

1. Power Center Server and Client on the same machine

2. Power Center Sever and Client on the different machines
 

76 what is the basic difference in these two setups and which is recommended?
 

77 Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
 

78 When you connect to repository for the first time it asks you for user name & password of repository and database both.
 

79 But subsequent times it asks only repository password. Why?
 

80 What is the difference between normal and bulk loading?
 

81 Which one is recommended?
 

82 What is a test load?
 

83 How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
 

84 What is the difference between a shortcut of an object and copy of an object? 85 What is mapplet and a reusable transformation?
 

86 How do you implement configuration management in Informatica?
 

87 What are Business Components in Informatica?
 

88 Dimension Object created in Oracle can be imported in Designer
 

89 Cubes contain measures
 

90 COM components can be used in Informatica
 

91 What is the advantage of persistent cache? When it should be used.
 

92 When will you use SQL override in a lookup transformation?
Two different admin users created for repository are ______ and_______

Two Default User groups created in the repository are ____ and ______
 
93 A mapping contains
1. Source Table S_Time ( Start_Year, End_Year )

2. Target Table Tim_Dim ( Date, Day, Month, Year, Quarter ) 

94 Stored procedure transformation : A procedure has two input parameters I_Start_Year, I_End_Year and output parameter as O_Date, Day , Month, Year, Quarter. If this session is running, how many rows will be available in the target and why?


95 Active/passive transformation (Lookup /sorted active or passive)
 

96 schema type, start schema can we have more than 1 fact
 

97 type of datawarehouse
 

98 what is ODs (differet type of storage)
 

99 session level optmziation (parameter set)
 

100 type of cache
 

101 connected/unconnected tranformation
 

102 bulk/normal mode (when we will go for it)
 

103 type of logs generate in informatica
 

104 how to set no of rejection (more than 10 rejction)
 

105 dependency of session (if one session fails will it continue next?)
 

106 what is mapplet, why we need it, can we have mapplet under mapplet
 

107 how achive update staergy without using tranformation update staergy
 

108 differnce between parameter and varaible
 

109 pcmcd differnt parameter
 

110 what is scd? explain scd3 ?
 

111 10k record in source and insert 10k in target (which mode we need to use?)
 

112 explain what details we get in workflow log
 

113 what is datawearhousr/why we need
 

114 what is rank transformation
 

115 sql override
 

116 if we have 5core record ,is it better to use bulk or normal mode
 

117 can we have lookup on file (source is file) how can we join file?
 

118 What's the restriction for Pushdown optimization, can we use aggregator pushdown optimization
 

119 why Joiner is required, we can use in source qualifier (what are differnt join)
 

120 How to pass value to un connected stored procedure
 

121 in Router without any condition, which group it will get oputput
 

122 SCD type 2, how to achive, how to update exisitng record
 

123 Parttion, what is pass throgh parttion
 

124 explain Performance tuning achived in your project
 

125 what DTM buffer size
 

126 How to check cache size
 

127 what peristant cache, how to get latest data using persitant cache, what details will contain in cache file
 

128 what is target/source override
 

129 what are all new features in 9
 

130 differnce between lookup and joiner
 

131 what is source/target commit interval
 

132 what is concurrent work flow, how to achive?
 

133 chekin/checkout (steps to taken care for checkout mapping)
 

134 why lookup is connected in 9
 

135 what is reporting tool used informatica

0 comments:

Post a Comment

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)