Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
balaya.ds
Participant
Posts: 27 Joined: Fri Dec 25, 2009 10:50 pm
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
Sudheer
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Sep 10, 2010 5:54 am
Slowly Changing Dimension stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Sep 10, 2010 6:57 am
Specifically, sounds like "type 2" SCD processing.
-craig
"You can never have too many knives" -- Logan Nine Fingers
prakashdasika
Premium Member
Posts: 72 Joined: Mon Jul 06, 2009 9:34 pm
Location: Sydney
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
Prakash Dasika
ETL Consultant
Sydney
Australia
mailravi.dw@gmail.com
Participant
Posts: 19 Joined: Sat Dec 19, 2009 8:50 am
Location: Chennai
Post
by 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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.