HOW DO YOU PARFORM INCREMENTAL LAOD ?

Answer Posted / praveen

Taking the Target defination as source and using the joiner
and update we can do the incremental loading


2.By using lookup transformation, keeping lookup on target
and companring.

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a sorter transformation?

657


What is informatica powercenter repository?

711


What is Session and Batches?

662


How to implement security measures using repository manager?

602


what is diff b/t sorter t/r and agg have the option sorter property...

1743






Partition, what happens if the specified key range is shorter and longer

2029


What can we do to improve the performance of informatica aggregator transformation?

616


How to load last n records of file into target table - informatica

598


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1125


What are the databases that informatica can connect to windows?

577


What is the benefit of partitioning a session?

623


What is a filter transformation?

564


What is persistent lookup cache?

601


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

709


What do you mean by channel change?

539