wht is cdc?how to use it in creation of mappings?
Answer Posted / sreekanth
CDC stands for change data capture
Daily several transaction may happen among those some may
adds new records to the OLTP and some transaction updates
the existing so we need to capture the changes then while
loading the data we need to update on the existing date ware
house with changes made to OLTP for this we will maintains
when created and when updated audit column in OLTP according
those fields we can load the data to targt.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Target increases every day even though no new record was inserted
can u give example for factless fact table
Explain lookup transformation source types in informatica
What is the function of aggregator transformation?
can you please explain me pre session and post session options?
Can we override a native sql query within informatica?
what is Active lock explain
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is status code in informatica?
How to do the error handling of if ur source is flatfiles?
What is data caches/ index caches?
What is the Rank index port in Rank transformation?
How can informatica be used for an organization?
How to convert multiple rows to single row (multiple columns) in informatica