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?
Best approach
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 32
- Joined: Tue Dec 20, 2011 8:03 am