DSXchange

Shashi, i observe that source record JRNL_HEADER does have a timestamp field DTTM_STAMP_SEC coming from source which u can compare with LASTUPDDTTM in tgt for incremental load.Otherwise, every row coming into PSFT warehouse(staging area) from source database is always timestamped with LASTUPDDTTM as...

Hi Ray, Thanks for quick reply. But i can not use temporary table option for the access problems that may arise while dropping and creating this tbl with every run, and the sequential file stage option as part of our development restriction. I think i will have to go for the Routine and variable opt...

Hi, i want to create a datastage server job with following functionality. Source contains columns like key, base amount. In a lookup transformation i do lookup against key col, i get data of following sort (key, base amount , PYEAR_NUM , PPERIOD_CD) 1 , 100 , 2003 , 01 2 , 500 , 2003 , 02 3 , 200 , ...