DSXchange

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

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.

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

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.