datastage

[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.

[Kirtikumar]

Very interesting!!!

Do all the tables have same metadata or different type of metadata?

[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..

[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?

[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

[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.