Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
- 2 Answers
- 10792 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajasekhar.
we can create a parameter file as previous_run_time and
current_run_time in the mapping. based on this time stamps
we can capture the new records which need to be insert and
update in the target table.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How you know when to use a static cache and dynamic cache in lookup transformation?
Enlist the various types of transformations.
Can u generate reports in Informatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Is stop and abort are same in informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain the difference between mapping parameter and mapping variable?
Explain pushdown optimization and types in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to partition the Session?
What is confirmed fact in dataware housing?
Describe data concatenation?
Why is sorter an active transformation?
What is primary and backup node?
Differentiate between reusable transformation and mapplet.
