DSXchange

Posted: **Fri Sep 10, 2010 4:02 am**

The below rule how to implement in datastage?

Transform record as per INSERT process type.
Lookup Acct

where EXPY_date = 'yyy/mm/dd'

IF not found
THEN
INSERT record
ELSEIF any of DELTA VALUE columns has changed
THEN
UPDATE record as per UPDATE process type
INSERT record
ELSE
Perform UPDATE CLOSE
ENDIF

Posted: **Fri Sep 10, 2010 5:54 am**

Slowly Changing Dimension stage.

Posted: **Fri Sep 10, 2010 6:57 am**

Specifically, sounds like "type 2" SCD processing.

Posted: **Mon Sep 13, 2010 11:48 pm**

The SCD stage does not exist in 7X, you can use change capture in conjunction with Insert/Update

Posted: **Tue Sep 14, 2010 12:22 am**

Use Change Capture Stage, Identify which is before dataset and after dataset. Based on the codes provided by Change capture stage then direct the data to the respective inserts and updates.

Thanks
Ravi

Posted: **Tue Sep 14, 2010 12:53 am**

prakashdasika wrote:The SCD stage does not exist in 7X, you can use change capture in conjunction with Insert/Update

Good catch!