hi all,
i have one problem in datastage i.e i have one source table (sequential file) it should be loaded into more than 100 target tables. the source contains table name in the sequential file based on that the data should be loaded into the particular target table.
datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
solution
u can use datastage macros to get the startdate&time
sorce--- Transformer- ---- TGT1 |
TGT100
in the transformer
source -------------- Target
DSLINK1 ------- DSLINK2
tablename |||| DSLINK1.cedevalue codevalue
cedevalue ||||| DSLINK1.desc1 desc1
desc1 |||| yourname rowupdateuser
recordstatuscode |||| DSJobStartDate rowupdatedate
Try this,uan hotcode the name value or parameterize it.
sorce--- Transformer- ---- TGT1 |
TGT100
in the transformer
source -------------- Target
DSLINK1 ------- DSLINK2
tablename |||| DSLINK1.cedevalue codevalue
cedevalue ||||| DSLINK1.desc1 desc1
desc1 |||| yourname rowupdateuser
recordstatuscode |||| DSJobStartDate rowupdatedate
Try this,uan hotcode the name value or parameterize it.