Informatica Interview Questions!!!!!!! Informatica Interview Questions!!!!!!!!!!!!!!!
1 Active/passive transformation (Lookup /sorted active or passive
2 When you connect to repository for the first time it asks you for user name & password of repository and database both.
3 why lookup is connected
4 Can a joiner be used in a mapplet.
5 What are active transformations.
6 Repository user profiles
7 explain what details we get in workflow log
8 How do u set a varible in incremental aggregation
9 Global and Local shortcuts. Advantages.
10 differnce between parameter and varaible
11 How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
12 what is reporting tool used informatica
13 Sequence generator, when u move from develoment to production how will u reset
14 bulk/normal mode (when we will go for it
15 How to run a session, which contains mapplet?
16 How do u recover rows from a failed session
17 Why use shortcuts(Instead of making copies
18 What are the new features of Power Center 5.0?
19 Slowly changing dimensions, types and where will you use them
20 Do u have knowledge in ralph kimball methodology
21 what is target/source override
22 SCD type 2, how to achive, how to update exisitng record
23 When do u use mapping parameters? (In which transformations
24 How do u implement unconn. Stored proc. In a mapping?
25 Whats there in global repository
26 In a concurrent batch if a session fails, can u start again from that session
27 what is concurrent work flow, how to achive?
28 How big was your fact table
29 What are conformed dimensions?
30 What are the modules in Power Center
31 How do you implement scheduling in Informatica?
32 where is the reject loader .
33 What did u do in source pre load stored procedure
34 Implementation methodology
35 differnce between lookup and joiner
36 When will you use SQL override in a lookup transformation?
37 connected/unconnected tranformation
38 Can u use flat files in Mapplets.
39 Can u create a flatfile target
40 What is a test load?
41 what peristant cache, how to get latest data using persitant cache, what details will contain in cache file
42 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
43 How do you use reject loader.
44 what is the meaning of complex transformation?
45 Where do u create/define mapping parameter and mapping variable?
46 what DTM buffer size
47 disable caching in a lookup transformation?
48 dependency of session (if one session fails will it continue next?
49 Do u have to change the reject file b4 using reject loader utility.
50 Have you worked with/created Parameter file
51 What is the meaning of up gradation of repository?
52 10k record in source and insert 10k in target (which mode we need to use?
53 in any project how many mappings they will use(minimum
54 Parttion, what is pass throgh parttion
55 What happens if the info. Server doesn’t find the session parameter in the parameter file?
56 How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
57 What's the restriction for Pushdown optimization, can we use aggregator pushdown optimization
58 What are variable ports and list two situations when they can be used?
59 What are active transformations? Name them.
60 How does the session recovery work.
61 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
62 How to pass value to un connected stored procedure
63 How will u convert rows into columns or columns into rows
64 in Router without any condition, which group it will get oputput
65 schema type, start schema can we have more than 1 fact
66 if we have 5core record ,is it better to use bulk or normal mode
67 Partition, what happens if the specified key range is shorter n longer
68 can we have lookup on file (source is file
69 what is the basic difference in these two setups and which is recommended?
70 what is rank transformation
71 How do you do error handling in Informatica?
72 What are session parameters ? How do u set them?
73 what is datawearhousr/why we need
74 What is the difference between sequential batch and concurrent batch and which is recommended and why?
75 How to check cache size
76 how to set no of rejection (more than 10 rejction
77 how achive update staergy without using tranformation update staergy
78 what are all new features in 9
79 What’s the layout of parameter file (what does a parameter file contain?
80 How can you run a session without using server manager?
81 Differences between version 7.x and 8.x.
82 what is mapplet, why we need it, can we have mapplet under mapplet
83 Why do u use Mapping Parameter and mapping variable?
84 What is the difference between normal and bulk loading?
85 What is a parameter When and where do u them when does the value will be created
86 Desing time, run time. If u don’t create parameter what will happen
87 Scheduling properties,whats the default (sequential
88 When u move from devel to prod how will u retain a variable
89 what is scd? explain scd3 ?
90 How does the server recognize the source and target databases. Elaborate on this.
91 can you avoid static cache in the lookup transformation? I mean can you
92 Differentiate between Load Manager and DTM?
93 explain Performance tuning achived in your project
94 what are factless facts? And in which scenario will you use such kinds of
95 What are Business Components in Informatica?
96 type of cache
97 pcmcd differnt parameter
98 what is source/target commit interval
99 what is ODs (differet type of storage
100 type of logs generate in informatica
101 session level optmziation (parameter set
102 Reusable transformation & shortcut differences
103 chekin/checkout (steps to taken care for checkout mapping
104 What are the main features of Oracle 8i with context to datawarehouse?
105 Which one is recommended?
106 What are the parts of Informatica Server?
107 type of datawarehouse
108 Can u access a repository created in previous version of Informatica?
109 What are the steps involved in the migration from older version to newer version of Informatica Server?
110 Performance tuning( what u did in performance tuning
111 How many transformations can be used in mapplets.
112 How do you change parameter when u move it from development to production.
113 sql override
114 Why Union transformation is active
115 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.
116 What is mapplet and a reusable transformation?
117 How do you implement configuration management in Informatica?
118 What is the difference between a shortcut of an object and copy of an object?
119 Filter transformation in the condition one of the data is NULL would the record be dropped.
120 why Joiner is required, we can use in source qualifier (what are differnt join