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 diff b/t sorter t/r and agg have the option sorter property...
What is mapping debugger?
What does update strategy mean, and what are the different option of it?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to improve the performance of a session using sorter transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Difference between Target-based loading and constraint-based loading?
How we can create indexes after completing the load process?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to update source definition?
where to store informatica rejected data?
Tell me about MD5 functions in informatica
How to use procedural logic inside infromatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain about Informatica server process that how it works relates to mapping variables?