Interested to Buy Any Domain ? << Click Here >> for more details...
wht is cdc?how to use it in creation of mappings?
- 6 Answers
- 22629 Views
- HSBC, I also Faced
- E-Mail Answers
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
Why is sorter an active transformation?
What are the measure objects?
What are batches?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Tell me about MD5 functions in informatica
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Explain informatica architecture - version 8 / 9
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
whats the logic to load the lower level of granularity of data to fact table.
What is update strategy transform?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is powercenter on grid?
explain abt ur project architecture?
What do you understand by SOA of Informatica?
