How or for what purpose look up transformation would be
useful in Sales or Banking Project?

Please reply!

Answers were Sorted based on User's Feedback



How or for what purpose look up transformation would be useful in Sales or Banking Project? Ple..

Answer / raj

For maintaining the complete history we need to look up on
the target table especially in sales and banking projects we
use SCD2 type mappings for maintain the complete history.

Is This Answer Correct ?    1 Yes 0 No

How or for what purpose look up transformation would be useful in Sales or Banking Project? Ple..

Answer / sunil reddy

Thankd for your reply.

Could you please explain me about transaction code?

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,


why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,


Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,


how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,


What are the measure objects?

0 Answers  






What is polling?

1 Answers  


hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,


What is a candidate key?

7 Answers   CTS,


1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,


What are the reusable transforamtions?

1 Answers  


where to store informatica rejected data?

0 Answers  


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers   CTS,


Categories