How to maintain updated information as well as tracking

srinivas143 · Post by **srinivas143** » Tue Jul 29, 2008 5:22 am

Hi All,

I had a requirement as follows.

I need to compare todays data and previous days data based on a key column and need to Insert new records and update the existing records...

scenario as follows...

previous day data

code
----
INR
USD

Todays data

code
----
INR
AUD

I need to compare the currency codes and If a new currency comes I need to insert the new record and update existing records.

And also I need to keep track of the new codes come in that day and existing codes which are not present in today's file
-------------------------------------
Resultant data need to contain as follows
Actual table
------------
code
----
INR
USD
AUD

Tracker table
-------------
AUD---New record
USD---Existing record which was not present in todays file

Any suggestions regarding what kind of stage I can use to do this scenario

Pls advise me

Kind Regards
Srini

keshav0307 · Post by **keshav0307** » Tue Jul 29, 2008 6:00 am

Read the parallel job developers guide for change data capture stage

AmeyJoshi14 · Post by **AmeyJoshi14** » Tue Jul 29, 2008 6:24 am

keshav0307 wrote:Read the parallel job developers guide for change data capture stage

hmmm...You can also use diff stage to achieve this purpose...

srimitta · Post by **srimitta** » Tue Jul 29, 2008 6:36 am

You can identify what is new & what is changed using CDC stage (Change Data Capture)
For new record Insert Code = 1
For Updated record Edit Code = 3
These codes are built-in in the CDC stage.

srinivas143 · Post by **srinivas143** » Tue Jul 29, 2008 8:20 am

Thank you all...will check