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 sequence generator transformation in informatica?
What are the different versions of informatica?
What is meant by a domain?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the types of lookup transformation?
what is Active lock explain
How do you change a non-reusable transformation to reusable transformation?
Explain the informatica workflow?
What do you understand by SOA of Informatica?
How many dimensions are there in informatica?
Explain lookup transformation in informatica
What are multi-group transformations?
What is meant by incremental aggregation?
How you can differentiate between connected lookup and unconnected lookup?
Mention few advantages of router transformation over filter transformation.