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

Repository user profiles

0 Answers  


What is repository manager?

0 Answers  


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  


how to move the mappings from your local machine to claint place?

2 Answers  


what is workflow varible

1 Answers   HP,






Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  


In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,


In session log thier should not be a single error how will u do

3 Answers   HCL,


What is IQD file?

1 Answers  


Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,


what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,


Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,


Categories