DSXchange

how to add current sysdate in my target table..???

Thanks in advance

What database? Most support their own methodology, like Oracle does with the keyword SYSDATE that you mentioned. Simply use Custom SQL, include all other fields in your data stream and insert 'SYSDATE' into your date/time field.

If you want to do it in DataStage, look up @DATE and @TIME for starters. You can get the current System time or the Job (really Transform) start time using functions or System Variables like these. Check your online help.