Page 1 of 1
datastage
Posted: Tue Sep 19, 2006 2:42 am
by karthegx
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.
Posted: Tue Sep 19, 2006 7:21 am
by Kirtikumar
Very interesting!!!
Do all the tables have same metadata or different type of metadata?
Posted: Tue Sep 19, 2006 7:30 am
by keshav0307
you can achhieve it in many ways.but befoer that please give mpre details on your requirement.like metadata of source and target etc..
Posted: Tue Sep 19, 2006 6:27 pm
by kumar_s
If understand properly, does your source file has both data as well as the name of the target table to which it has to be loaded?
Posted: Tue Sep 19, 2006 11:24 pm
by karthegx
Hi,
the source file contains the tablename and all the target tables have the same metadata.
the source has these columns,
tablename
cedevalue
desc1
recordstatuscode
but the target tables has these data,
codevalue
desc1
rowupdateuser
rowupdatedate, so please help me for this issue
solution
Posted: Wed Sep 20, 2006 12:10 am
by asoka_dwh
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.