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
What is the difference between informatics 7x and 8x and what is latest version?
Explain the shared cache and re-cache?
How to extract sap data using informatica?
What can we do to improve the performance of informatica aggregator transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is a snowflake schema?
How to implement security measures using repository manager?
Explain sessions. Explain how batches are used to combine executions?
Explain your project of banking domian.
How can one identify whether mapping is correct or not without connecting session?
How many transformations can be used in mapplets.
What is data caches/ index caches?
Explain target update override in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to extract sap data using informatica? What is abap? What are idocs?