DSXchange

Hi, I am new to DataStage and I never worked on XML. I got a requirment where, 1. We get an XML file which we need to accept and Validate it with XSD provided. Need your input on what validations need to be done and how? 2. Clients do not wish to see the elements in the XML that do not have data in ...

Looks like issue was with Data. This is resolved now. Thank you anyways.

Thank you for noticing it. I am new to DataStage so i am still confused about the syntax. Thank you all. I corrected the syntax and that fixed the issue and for safe side i used explicit transformation too.

Yes... I did...

I have created a decimal column in transformer output and gave the following expression...

Table_Read.Source_Col[21,25]

I am Migrating Data from DB2 to Oracle. I am stuck on the timestamp column. If the colum values are null it is being transformed to '*******************' !! I have tried IsNull in the transformation but it does not work. I MUST accept a null value (not a hypothetical date such as 01-01-0001). If I a...

I am Taking Data from flatfile and loading to sequentual file. In flat file it is just a single column which I am dividing into many columns based on requirment. In one case i have to pick data from 21st to 25th char of source file and have to save it as decimal in target. For Example, the data is '...