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

Please reply!

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define joiner transformation?

598


What is persistent lookup cache?

607


EXL informatica Questions

938


Explain where to store informatica rejected data? How to extract the informatica rejected data?

584


What is pmcmd command?

679






Which development components of informatica have the highest usage?

600


What does refresh system mean, and what are its distinctive choice?

571


What is exclusive and normal mode for repository services?

717


explain one complex mapping with logic? sales project?

6154


What is a transaction control transformation?

768


What is informatica?

686


What is repository manager?

538


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

601


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

642


What is DR strategy for Informatica project?

708