Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
- 2 Answers
- 10771 Views
- I also Faced
- E-Mail Answers
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 different lookup cache(s)?
how we can load rejected record's at run time?(not through bad files)
What are multi-group transformations?
Explain the difference between mapping parameter and mapping variable?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain the difference between a data warehouse and a data mart?
To import the flat file definition into the designer where should the flat file be placed?
What are the restrictions of union transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is difference between a gateway node and worker node?
What is the function of aggregator transformation?
How would you join a node to the already existing domain?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How you know when to use a static cache and dynamic cache in lookup transformation?
How might one distinguish in the case of mapping is right or not without associating session?
