DSXchange

hi my job is straight forward one generating a surrogate key using dtabse sequence in oralce ..job looks like this source is oracle connector with 3 columns and surrogate Key generator and target is sequential file ..i am getting this following error .. SK_GEN: Caught exception from runLocally(): AP...

i need to fetch the inserted/updated/deleted records from source ..means those will come from chnage capture stage after comparing source and reference data(target data)....how can i do that incrementally

Hi i am new to datastage ... soure-sql server target-oracle datastage 8.7 unix environment i am trying to load incrementally using chnage capture stage but i have a problem in refernece data(copy of target)..i am fetching letest data from source but after initial load when i tried to load the second...