Top 135 Informatica Interview Questions

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

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