how to implement in datastage?

balaya.ds · Post by **balaya.ds** » 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

ray.wurlod · Post by **ray.wurlod** » Fri Sep 10, 2010 5:54 am

Slowly Changing Dimension stage.

chulett · Post by **chulett** » Fri Sep 10, 2010 6:57 am

Specifically, sounds like "type 2" SCD processing.

prakashdasika · Post by **prakashdasika** » 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

mailravi.dw@gmail.com · 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

ray.wurlod · Post by **ray.wurlod** » 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!