Interested to Buy Any Domain ? << Click Here >> for more details...
wht is cdc?how to use it in creation of mappings?
- 6 Answers
- 22637 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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is rank transformation?
Is it possible to revert a global repository to local one and why?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
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.
How to open an older version of an object in the workspace?
Explain sessions?
how to load dimension table and fact table. plz tell me the steps.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How can you validate all mappings in the repository simultaneously?
How do you update the records with or without using update strategy?
Scheduling properties,whats the default (sequential)
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to elaborate tracing level?
