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

What is domain in terms of informatica?

561


what is degenerated dimension?

3148


How to generate sequence numbers?

616


What are session parameters ? How do you set them?

1375


What are ETL Tools?

664






How is union transformation utilized?

565


How to update source definition?

627


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1683


How to extract the informatica rejected data?

749


What is depict expression change?

614


design of staging area?

1585


What is main use of mapplet?

654


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

574


What is deployment group?

680


What is the difference between stop and abort in informatica

656