Is it possible to have any Database stage (say DB2,Oracle,ODBC) in a job, that can support different meta data.
For example , can I use a single DB2 stage simultaneously for different metadata :
1. emp_name varchar
emp_code Integer
2. emp_code integer
emp_location varchar
Database stage
Moderators: chulett, rschirm, roy
You can use different stages in same job, but not different metedata in same Stage at runtime. Datastage is Metadata driven, hence, you need to specify the metadata will before the job is complied. There are few option like schema file and RCP, where you can have flexibility to change the Metadata.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Database stage
How can we use schema file or RCP with a database stage to achieve the compatibility with different meta data.