Query on Runtime column propagation
Posted: Tue Jan 25, 2011 8:38 pm
Hi,
I'm trying to use Runtime column propagation in DS8.1.
Job:
Oracle Ent ---> Copy ---> DataSet
I have enabled RCP for project and checked the Runtime column propagation box in Oracle and Copy stage. I have defined metadata for 5 columns in Oracle and Copy stage but selecting 10 columns through user defined sql query option from Oracle stage.
Runtime column propagation is not working. It is moving only 5 columns I defined in stage metadata to DataSet.
If my understanding is correct, schema file is required for Sequential file and other file like stages. And Oracle Ent and copy stage should work without schema file. Moreover I do not find any property in Oracle Ent stage to provide schema file.
Can some one help me with this?
Thanks,
Shashank
I'm trying to use Runtime column propagation in DS8.1.
Job:
Oracle Ent ---> Copy ---> DataSet
I have enabled RCP for project and checked the Runtime column propagation box in Oracle and Copy stage. I have defined metadata for 5 columns in Oracle and Copy stage but selecting 10 columns through user defined sql query option from Oracle stage.
Runtime column propagation is not working. It is moving only 5 columns I defined in stage metadata to DataSet.
If my understanding is correct, schema file is required for Sequential file and other file like stages. And Oracle Ent and copy stage should work without schema file. Moreover I do not find any property in Oracle Ent stage to provide schema file.
Can some one help me with this?
Thanks,
Shashank