DSXchange

Didn't help really!!! Thank you...

You must have linked the XML stage to some output stage? The output in XML Stage shows the columns present in the next stage attached to it. check what columns are present in the last stage.

Hi, I want to display all null value fields in XML. So what I did is, I modified my .xsd file and updated all fields with nillable="true" option. And my job design is like this, External Source Stage->XML Stage In XML Stage, I took Parsing Step and Composing Step. In both Steps, I updated ...

Hi, My XML File is like this, <Batch> --<A> --<B> --<BatchDetails> ----<C> ----<D> --<Worksheet> ----<E> ----<F> ----<Items> ------<G> ------<H> My Job structure is like this, External Source->XMLStage(to divide data)->3 Transformer(one for Batch,Worksheet,Items each)->XML Stage<To form XML file aga...

I got the solution. We can add multiple regroups. The scope of the regroup should be the parent group instead of "top"

Hi, I modified a .xsd file to show NULL fields in XML. I modified the code in following format, Old Code: <xs:element name="FirstName" type="xs:string"/> New Code: <xs:element name="FirstName" Nillable="true" type="xs:string"/> I can see the Null Col...

Hi, I have a job where I take an XML as input to XML Stage, Send it to multiple Transform Stages, Modify Data and then Compose Data. As of now, I got till here, Step 1. Take Input XML in XML stage, Parse the data into multiple Transform Stages (If there is 5 levels of Data, I divided the data into 5...

Hi, I am running a simple source to target data migration job. My log says following, SOURCE_TABLE,0: Number of rows fetched on the current node: 897. TARGET_TABLE,1: Number of rows inserted on the current node: 448. TARGET_TABLE,0: Number of rows inserted on the current node: 449. But when i look i...

We have a DataStage process that accepts tilde delimited test files and generates an XML files. Currently we have three interfaces (lets say a,b,c) each processing at different times. Shown below is the schedule of each of the interface process Interface Schedule A 9am, 3pm, 9pm B 7:30am, 10:30am, 5...

Any one have any other ideas???

Hi, We are trying to replace ORA Bulk Stage with Oracle Connector. In ORA Bulk Stage we have options 'Before Stage Subroutine' and 'After Stage Subroutine' with input values. In Old job I am calling a Routine in After Stage Subroutine with input values. But in oracle connector stage I don't see this...

Its Empty (""). Please try to remember. I searched but I didn't find it.

I am doing a simple DB2 to Oracle ETL. Table name is passed runtime so there is no point in adding columns. So I used Runtime Column Propagation. But the blanks in DB2 when passed to oracle are treated as NULL and the job fails. Is there a way to do NULL Handiling in ORACLE Connector or DB2 Connecto...

There is an Old job in my project where a simple DB2 to Oracle migration is going on with out any transformation. Db2 and Oracle Enterprise Stage is used, not the connectors. I am running the job in DS8.7 now. The Source Table data looks like this, Column_Name Size COLUMN1 10 COLUMN2 20 COLUMN3 4 Wh...

Can you suggest me some other Valdiations that can be done apart from the ones in XML Stage?