DSXchange

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

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.