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 ....
selective tables data
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers