Modify stage specification has more than one conversions
Posted: Wed Jun 29, 2011 12:09 pm
Hi All,
Please clarify my doubt regarding Modify stage,
i am using two modify conversions in one specification like
NEW_COLUMN = COLUMN_A; COLUMN_C = handle_null(COLUMN_C,0);
Reason for using like this is, i will parameterize the specification and pass that at run time. i have 100 jobs with different layouts and load into 100 tables with schmema name using RCP, and i have to do datatype conversions, drop an null handle in all files.
If we can do this then one job is enough to load data from file to table.
i see in DS parallel advanced guide like this but there using $osh command.
i am trying to implement but getting errors.
Please give us suggestions and let us know how to achieve this.
Thanks in Advance.
Please clarify my doubt regarding Modify stage,
i am using two modify conversions in one specification like
NEW_COLUMN = COLUMN_A; COLUMN_C = handle_null(COLUMN_C,0);
Reason for using like this is, i will parameterize the specification and pass that at run time. i have 100 jobs with different layouts and load into 100 tables with schmema name using RCP, and i have to do datatype conversions, drop an null handle in all files.
If we can do this then one job is enough to load data from file to table.
i see in DS parallel advanced guide like this but there using $osh command.
i am trying to implement but getting errors.
Please give us suggestions and let us know how to achieve this.
Thanks in Advance.