Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
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
What is the use of source qualifier?
What is data movement mode in Informatica and difference between them?
What is target load order?
What is Index Caches size?
what is the difference between informatica6.1 and infomatica7.1
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the commit type if you have a transaction control transformation in the mapping?
What are the types of caches in lookup? Explain them.
my source is junk data how will u remove that junk data by using unix please any one replay me
What are batches?
What are the differences between joiner transformation and source qualifier transformation?
What are the different options available for update strategy?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
can any one give some examples for pre sql and post sql(Except dropping and creating index).