Real time implementation of change data capture

[ksudhir466]

I have one requiement for real time data integration, whenever data gets changed at source level need to load to datawarehouse. I need to implement it through data satge job which checks for data change at source and trigger a job which loads data to datawarehouse.Have to take care of latency also as data is in huge volume.

can anyone suggest pls

Thanks
Sudhir

[ray.wurlod]

Don't use DataStage to do the checking - it can only be after the event. Use one of the newer technologies, such as Change Data Capture, which can feed the deltas into DataStage jobs.