hi all,
I wanna parametrize the column level field. How to do that? I've searched the forum but i couldn get any thing regarding this stuff.
Consider if A & B are my columns and if '123' & 'abc' will be the default value for A & B columns respectively. The default value may change or may not in future. So for this reason i wanna parametrize the coulmns A & B. Will this method will be fine or any other method is there to meet the reqiurement. If so let me know...
So could any one tell me how to parameterize the column derivations...
parameters
Moderators: chulett, rschirm, roy
parameters
Thanks in advance...
veera...
veera...
Hi!
Please inform which in stage you intend to parameterise column.
For eg if you are usind a db2 database stage DB2/UDB API then you simply need to put '#<Job Parameter>#' in Output --> Column --> Derivation and it would fetch the value of job parameter in that column.
Or you can modify SQL to include job paramter in it.
So please specify which stage inparticular you want to use.
Please inform which in stage you intend to parameterise column.
For eg if you are usind a db2 database stage DB2/UDB API then you simply need to put '#<Job Parameter>#' in Output --> Column --> Derivation and it would fetch the value of job parameter in that column.
Or you can modify SQL to include job paramter in it.
So please specify which stage inparticular you want to use.
Hi!
Please inform which in stage you intend to parameterise column.
For eg if you are usind a db2 database stage DB2/UDB API then you simply need to put '#<Job Parameter>#' in Output --> Column --> Derivation and it would fetch the value of job parameter in that column.
Or you can modify SQL to include job paramter in it.
So please specify which stage inparticular you want to use.
Please inform which in stage you intend to parameterise column.
For eg if you are usind a db2 database stage DB2/UDB API then you simply need to put '#<Job Parameter>#' in Output --> Column --> Derivation and it would fetch the value of job parameter in that column.
Or you can modify SQL to include job paramter in it.
So please specify which stage inparticular you want to use.
hi sameena,SAMEENA wrote:Hi!
Please inform which in stage you intend to parameterise column.
For eg if you are usind a db2 database stage DB2/UDB API then you simply need to put '#<Job Parameter>#' in Output --> Column --> Derivation and it would fetch the value of job parameter in that column.
Or you can modify SQL to include job paramter in it.
So please specify which stage inparticular you want to use.
consider the following scenario
input : sequential file
output : odbc stage
the data from the input file needs to be loaded into ODBC stage thru a transformer.
Sameena,
i've one more question to ask you
if i parametrize like '#<Job Parameter>#' as u said, will the output be parameter name alone only na... cos it will just produce the output whatever in the double quotes... Have you ever tried this before? Why am asking this, I've tried the same when the output stage was just a sequential file. Will it make any difference? i mean the output stages...
Hope you will get my point.
Thanks in advance...
veera...
veera...