Informatica Interview Questions For Experienced

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

fact tables.


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