What is the difference between a connected look up and unconnected lookup?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


how to load duplicate row in a target

4 Answers  


What is sorter transformation?

0 Answers  


what happens if you try to create a shortcut to a non- shared folder?

1 Answers  


What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,






Write the prerequisite tasks to achieve the session partition?

0 Answers  


What do you mean by filter transformation?

0 Answers  


If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  


there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  


A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  


I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  


Describe two levels in which update strategy transformation sets?

1 Answers  


Categories