Database stage

mydsworld · Post by **mydsworld** » Thu Feb 22, 2007 12:43 am

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

kumar_s · Post by **kumar_s** » Thu Feb 22, 2007 1:06 am

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.

mydsworld · Post by **mydsworld** » Thu Feb 22, 2007 1:19 am

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

kumar_s · Post by **kumar_s** » Thu Feb 22, 2007 1:45 am

No, not available in Database stages.