wht is cdc?how to use it in creation of mappings?
- 6 Answers
- 20652 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / bidhar
CDC is used when you want to pull the records which have
changed or newly added in the OLTP system.
Normally the OLTP tables have 2 columns
last_updated_timestamp and Added_timstamp.
Whenever a new record is added for the first time in these
tables then both the columns have the same timestamp ie
System timestamp.
Then when that particular record is changed only the column
last_updated_timestamp will change and the other column
Added_timstamp will remain same forever.
Now you need to pull this record when it was added as well
as when it was modified to keep your warehouse in sync with
OLTP system.
So based on last_updated_timestamp column (not
Added_timstamp)you need to pull the records.
This can be achieved by overriding the SQ query in the
where clause.
Example :- if product table in OLTP has 2000 records on
11th may and on 12th may 10 new records have come up and 5
records have been changed.Then in the next load 15 records
should be pulled to your warehouse.
Select Prd_nam,Typ,grp,category from product where
last_updated_timestamp>&&date_parameter
This is your SQ override query.
&&date_parameter is a mapping parameter which can be picked
up from a file.(you need to have the previous load max date
in that file which will be used as mapping parameter).
Hope this clears your doubt.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
How can you differentiate between powercenter and power map?
What are multi-group transformations?
What are the prerequisite tasks to achieve the session partition?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is Cognos script editor?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is event and what are the tasks related to it?
How to call shell scripts from informatica?
On which transformations you created partitions in your project?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a repository? And how to add it in an informatica client?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How you know when to use a static cache and dynamic cache in lookup transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
