DSXchange

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

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.

How can we use schema file or RCP with a database stage to achieve the compatibility with different meta data.

No, not available in Database stages.