wht is cdc?how to use it in creation of mappings?
- 6 Answers
- 21682 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / infa developer
Not always necessary to be a Date field. When there are 5
key colummns and you want to check if any of them changed
and would like to extract only those records with these 5
key column values updated then you will have use this
concept of change data capture.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
State the limitations where we cannot use joiner in the mapping pipeline?
Why sorter is an active transformation?
How to update source definition?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a joiner transformation and why it is an active one?
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?
where to store informatica rejected data?
What is the need for an etl tool?
Explain 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?
Could you explain what is enterprise data warehouse?
Can we create a Integration service without a Repository service and vice versa?
explain about unit testing? in real time?
Explain sessions?
Explain lookup transformation is active in informatica
what is diff b/t sorter t/r and agg have the option sorter property...
