Slowly Changing Dimension stage will support RCD?

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

Post Reply
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Slowly Changing Dimension stage will support RCD?

Post by SURA »

Hello All

Slowly Changing Dimension stage in 8.5 is capable to handle Rapidly Changing Dimension (For Type 2) ?

Example:

In the same run for the key 'A' changed values as "DESC*"


A,DECS,Timestamp
A,DESC1,Timestamp
A,DESC2,Timestamp

Thanks in Advance
DS User
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes. Essentially, the pertinent parts of the dimension table are cached in memory.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply