Page 1 of 1
Inserting SYSDATE and Jobname to Oracle table
Posted: Thu Dec 01, 2011 1:41 am
by vskr72
I am loading an Oracle table with daat from a SEQ file. THe table need a Sysdate and Job_name. Is it possible to derive these without using transformer stage? Just curious?
Kumar
Posted: Thu Dec 01, 2011 6:17 pm
by major
hi,
In your case the only other way is to populate sysdate and jobname in the seq file which you are loading to oracle table.
Thanks
Major
Posted: Thu Dec 01, 2011 6:18 pm
by ray.wurlod
SYSDATE yes.
JobName yes.
But only if you use user-defined SQL in the database stage, with SYSDATE specified explicitly and the JOBNAME hard-coded from the job that it's run from.
Posted: Thu Dec 01, 2011 11:35 pm
by chandra.shekhar@tcs.com
Since you are using a Sequential File as a source, I dont think so that you can populate sysdate and jobname except in Tfr.
Posted: Fri Dec 02, 2011 12:42 am
by ray.wurlod
Read my response again carefully.