Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.

Answer Posted / amarnath

pass the records to the lokup transformation. u get a new
lookup port, pass this to router. in router 1st condition
newlookuprow =0 second newlookuprow =1. pass the "0" to
update strategy for update and pass the "1" to another
update strategy for insert.

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between informatics 7x and 8x and what is latest version?

549


Explain the shared cache and re-cache?

617


How to extract sap data using informatica?

610


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

620


Whats the difference between informatica powercenter server, repositoryserver and repository?

681






What is a snowflake schema?

573


How to implement security measures using repository manager?

608


Explain sessions. Explain how batches are used to combine executions?

601


Explain your project of banking domian.

1220


How can one identify whether mapping is correct or not without connecting session?

885


How many transformations can be used in mapplets.

1466


What is data caches/ index caches?

619


Explain target update override in informatica

635


if we have a delimiters at unwanted places in a flat file how can we over come those.

1572


How to extract sap data using informatica? What is abap? What are idocs?

562