Interview Question for Informatica

Informatica-

1. What all the transformations you worked on?

2. New features in Informatica 9

--Active lookup, Session log file size can be controlled in real time, Cold start option in Workflow monitor, Choose integration service from monitor, dead lock resilience etc. Refer online for more details.

3. How can we use active lookup in Informatica 9?

--Return more than one rows on multiple match

4. Difference between connected lookup and unconnected lookup.

--Online help…

5. Can we return multiple columns using unconnected lookup?

--Yes, concatenate multiple columns into single port and return that port.

6. When should we go for unconnected lookup?

--Same lookup need to be used multiple times in the same mapping and for conditional calling

7. Difference between static cache and dynamic cache.

--Online help…

8. When do we use Persistent cache

--If same lookup is being used in multiple sessions then use persistent cache.

9. How exactly dynamic lookup cache works?

--Online help…

10. How to select distinct records from flat file source?

--Using sorter and use distinct option.

11. How to select distinct records from flat file source without using sorter?

--Using Aggregrator

12. Can we write sql override for flat file source?

--No…

13. What are the types of joins present in Infromatica?

--Normal, Master outer, detail outer and full outer…

14. How to decide which table should be master or detail and how caching is done.

--Generally table with less number of unique Rows will be master because master table is cached and for each record in master table – full table scan is done for detail table.

15. Scenario on filter and router transformation about which transformation should be used when?

--Refer some scenarios on these…

16. How to convert rows into columns—

--Normalizer transformation.

17. Which are active and passive transformations you have used?

18. How to divide source data...