DSXchange

If I replace XML Input stage with Sequential file, I could see 10 Messages. But whenI bring back XML Input Stage, I could see data coming from only one message not from all 10 messages.

Over all, it processig only first message, and remaining 9 are not getting processed.

Hi, I have a source system which stores XML message in Oracle database as CLOB. I'm trying to read the CLOB messages and loading them into another table in tabular form columns. To acheive it - am reading data from Oracle connector and processing them as XML Data through XML Input Stage. Now the iss...

Default we kept it as 2000 and tried increasing upto 10,000. Nothing hasn't seem fruitful. Does it seem fine, if we double Nodes in configuration file. Currently we have 4-Node configuration and am thinking of recreating with 8-Node configuration? I know, it's more to do with Database transactions b...

I can't use Oracle enterprise stage here because it's not supporting reject link from target database when job runs with RCP.

Hi, Am using Oracle connector stage with load method as 'Insert Else Update'. but the amount of data for Update will be much bigger and higher than Inserts. Because of my 'Insert Else Update' load method, job takes atleast 3 hours to update 0.3 million records. If I use 'update else Insert', job pop...

Now i am getting the following error after running for few minutes. AfterJob (fatal error from DSAttachJob): Job control fatal error (0) (DSCloseJob) Cannot refer to own job handle (DSAttachJob) Failed to lock job after 1800 seconds Since i am calling the DSAttachJob in After Job routine by checking...

Hi All, I have written an After-Job routine to retrive the Job statistics. My job is hanging when it is encoutering the command DSAttachJob and the State of the job is always running. I am not sure why it is behaving this way. Here is my roUtine: $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H ...

eostic,

Can you brief us on how to create and use Xslt in the Xml Transformer stage to create independent multiple XML files


Thanks..

Take us higher up...what is your ultimate goal here? Having 50 different output (for different nodes, etc.) is entirely do-able within the Stage...but the links have to be defined and in your Job.....the Stage will take care of sending the output to the appropriate link depending on the incoming co...

1. Will XSLT helps in converting relational/tabular data into XML data?, I thouhgt, it needs only XML data as input to do any processing... 2. If XSLT supports relational data to XML conversion, then, I have 50 CSV files & am using 50 differernt corresponding schema files to read them in a singl...

We have set of nearly 50 CSV files out of which we have create same set of 50 XML files in a single datastage job. For this we are trying to make use of Schema file functionlaity for reading the CSV files. so My design would be like: Sequential --------> Copy Stage --------------->XML Output Stage S...

ArndW,

I am using the same mechanism of Rejecting the rows in the coulmn import stageusing the property Reject Mode=Output. But it is not rejecting the records that have null values in not null columns


Thanks

ArndW,

This option of keeping a reject link to the input file will not work in our case since we are reading the whole record as a single column in our DataStage job.

Using this default value it will load into the target table with this default value for all the records that have null in the source for a particular NOT NULL column but i actually want to reject these records that are null for a not null column

Ya but it was not working even if that is not expilictly mentioned as Not NULL. I just tried trail and error on the schema file. By default the coulmn are not null in the schema file. Can u please suggest on how to procedd to handle not nulls using Schema files. Is there any environment variable to ...