Data Set Usage
Posted: Tue Jul 25, 2006 4:48 am
Hi all
This is a wonderful site and thanks to all for their posts.
Iam a newbie in Ascential datastage.
I need to design a job which can concetenate 3 columns from a table, 3 cols from another table and 2 cols from a view and give an output with all 8 cols.
I have designed 3 jobs to accepts table cols in ODBC stage and give out .ds files at the output.
Now i have designed one more job which has 3 data set stages at input, a funnel and a data set stage at the output.
The problem is what should i load in the output -> colums tab of the data set stage at input?? I mean which kind of file should i choose while importing in the table definitions window to load the colums of .ds file.
Plz respond.
Thanks
This is a wonderful site and thanks to all for their posts.
Iam a newbie in Ascential datastage.
I need to design a job which can concetenate 3 columns from a table, 3 cols from another table and 2 cols from a view and give an output with all 8 cols.
I have designed 3 jobs to accepts table cols in ODBC stage and give out .ds files at the output.
Now i have designed one more job which has 3 data set stages at input, a funnel and a data set stage at the output.
The problem is what should i load in the output -> colums tab of the data set stage at input?? I mean which kind of file should i choose while importing in the table definitions window to load the colums of .ds file.
Plz respond.
Thanks