selective tables data

basu.ds · Post by **basu.ds** » Fri May 30, 2008 4:33 am

hi
I have requirement like i have configuration it contains list of tables. i have to select table name and from table i have to select data for lgreaterthan one year how it can be done in datastage.
eq:
no tablename
1. employeetable
2.Department table
3.error table
first i have select data from employee table then from departmenttable and so on ....

bkumar103 · Post by **bkumar103** » Fri May 30, 2008 4:47 am

For each table you have to write the seprate extraction job, because all the table will have different metadata. If all the table has the same metadata then you can pass the table name as the parameter.

basu.ds · Post by **basu.ds** » Fri May 30, 2008 4:53 am

yes my metadata same for all tables can you alobrate on this please

chulett · Post by **chulett** » Fri May 30, 2008 6:15 am

You have an 'employee', 'department' and 'error' table and they all have the same metadata? I find that hard to believe. Seems like you'll need to build X jobs and then have an intelligent process that reads your list of tables and determines which job to run based on the name found. Perhaps using some kind of a lookup structure.