Page 1 of 1
Parametersing Table definitions?
Posted: Wed Mar 30, 2011 2:48 am
by jaksani
Hi,
I would like to create a reusable job by parameterising everything.
I do not know whether it is possible in datastage or not.
Please let me know how to do if it can be done .
Posted: Wed Mar 30, 2011 6:54 am
by chulett
Define 'everything'... and what exactly would this job be doing? Simply moving data unchanged from source to target? Have you looked into the use of RCP and schema files?
Posted: Wed Mar 30, 2011 9:22 am
by GJ_Stage
Yes. It is possible using schema file (this is for reading seq file to writing into table). Only one DS job is enough for that you need to pass schema file name and tablename and anyother parameters.
Posted: Wed Mar 30, 2011 11:46 pm
by jaksani
Thanks!
Yes, My aim is move data from source to target location.
Please let me know where can I get more information on Schemas.