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
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?
What is aggregator transformation in informatica?
How to join three sources using joiner?
What is the meaning of decode in informatica?
What is xml source qualifier transformation in informatica?
How we can use union transformation?
What are the transformations that are not supported in mapplet?
What is an active transformation?
EXL informatica Questions
What are active transformations.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is joiner transformation in informatica?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is fact table? Explain the different kinds of facts.
difference between repository database and repository service?