If we have 1000 rows were loaded in to datawarehouse and
next day the source have 1010 rows so, how can we loaded
only updated rows into target.

Answer Posted / aswinigallery@gmail.com

Yes, we can use scd type 1 (only update flow).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between informatica6.1 and infomatica7.1

1729


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

625


Explain dynamic target flat file name generation in informatica

655


What is the need of an ETL tool?

648


can anyone explain me about retail domain project in informatica?

7446






What are active transformations.

1197


What is rank index in rank transformation?

615


What are roles and groups and benefits of using them?

574


can we override a native sql query within informatica? How do we do it?

658


Explain target update override in informatica

638


Design a mapping to load a target table with the following values from the above source?

889


Why filter transformation is an active one?

571


Where can we find the throughput option in informatica?

608


Explain the difference between mapping parameter and mapping variable?

609


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3330