Best approach
Posted: Sun Jun 03, 2012 12:26 am
In my job I have one STG_CSPR_RECON_HAND table which contains rslt_1,rslt_2,rslt_3,rslt_4,rslt_5.......rslt_25(source columns)
For each record I need check rslt_1<>0.0 then "ohlbr" assign to result_cd out put column and "rslt_1"(hard coded value) assign to rslt_fld_cd column
For each record I need check rslt_2<>0.0 then "DIRECT"assign to result_cd out put column and "rslt_2" (hard coded value)assign to rslt_fld_cd column2
For each record I need check rslt_2<>0.0 then "DIROTP" assign to result_cd out put column and "rslt_3" (hard coded value)assign to rslt_fld_cd column2
------
------
-------
For each record I need check rslt_25<>0.0 then "FMOHSA"assign to result_cd out put column and "rslt_25" (hard coded value)assign to rslt_fld_cd column2
My job design:
teradata connector stage-----> transformer----------->(25 out put links)--------> funnel----> teradata connector stage.
Is there any best way to implement this scenarao?
For each record I need check rslt_1<>0.0 then "ohlbr" assign to result_cd out put column and "rslt_1"(hard coded value) assign to rslt_fld_cd column
For each record I need check rslt_2<>0.0 then "DIRECT"assign to result_cd out put column and "rslt_2" (hard coded value)assign to rslt_fld_cd column2
For each record I need check rslt_2<>0.0 then "DIROTP" assign to result_cd out put column and "rslt_3" (hard coded value)assign to rslt_fld_cd column2
------
------
-------
For each record I need check rslt_25<>0.0 then "FMOHSA"assign to result_cd out put column and "rslt_25" (hard coded value)assign to rslt_fld_cd column2
My job design:
teradata connector stage-----> transformer----------->(25 out put links)--------> funnel----> teradata connector stage.
Is there any best way to implement this scenarao?