DSXchange

Can we use source table, target table and key column as a parameters ? If not, is there any possiblilties to run a single job by changing the key column name or source table or target table.

That and spend some time with any XML savvy people that you work with and who are willing to help. Any non-DataStage specific terms, like DTD and XSD, can be easily googled for. The CLOB part with be the problematical part, regardless of what is in it. Better to have used Oracle's XMLTYPE field for...

I need to parse the xml elements which are stored as xml messages in Oracle CLOB data type. My question is whether WebSphere MQ / Web Services Client / Web Services Transformations / XML Reader / XML Writer / XML Input, Output, Transformer stages are useful for the requirement or not. What exactly W...

CLOBs are not well supported, as they are not typically targets of the "T" in "ETL"... much less the other two letters. You would have been better off storing XML in Oracle as an XMLTYPE rather than a CLOB, at least that way you could query it. Can you be more specific exactly w...

How to read xml messages stored in oracle DATA CLOB using DS What are are stages need to use for source, target, etc. How to import meta data. Is it possible to read and write/load xml messages which contains information. Thanks in ADV

Thanks.But what exactly is the following .Is it a Ascential learning course.
Enrol in DataStage Best Practices class (DS306), where handling SCDs is discussed.
Examine the Intelligent Assistant for SCDs.