Hi,
Newbie Questions
I am reading sequential files using file pattern & trying to load temp tables for each changing time period(YYMM). I need to pass parameter to Oracle stage to create tables with changing YYMM?
Have a JOB parameter for the period and use it as part of the table name in the DATABASE stage.
something like
TEMPTABLE_#Param_Period#
Every time you run the job, you will create a new table. But you need to be mindful about the fact that when the period doesn't change, table need to be dropped or handled correctly.
kris wrote:Have a JOB parameter for the period and use it as part of the table name in the DATABASE stage.
something like
TEMPTABLE_#Param_Period#
Every time you run the job, you will create a new table. But you need to be mindful about the fact that when the period doesn't change, table need to be dropped or handled correctly.
The Parameter is a field in the sequential file. How do I pass it to the table name in the same job... If I say #DSLinkname.fieldname# in the table name, job parameter doesn't get resolved. I am using Oracle Enterprise stage with load option.
You can't. It must be a Job Parameter passed in from another source, like another job or routine. A Sequence job could easily do the trick, read the file to get the parameter value and then pass it to your processing job.
-craig
"You can never have too many knives" -- Logan Nine Fingers