DSXchange

Hi, I am trying to capture all the information including repetition elements from XML. I can only capture different values for the key element specified and for all the other elements i get repeated information same as the first record. Example: Let us say this is my XML. <customers> <customer id=&q...

There are 400 xml files in that location. Each file is named after a number like "12000.xml". All these files are in a seperate folder. I was using teh same path earlier and it worked. Can you please tell me what do i need to do now to resolve this issue. In future there are going to be li...

There are 400 xml files in that location. Each file is named after a number like "12000.xml". All these files are in a seperate folder. I was using teh same path earlier and it worked. Can you please tell me what do i need to do now to resolve this issue. In future there are going to be li...

Hi, I had a job which uses xml input stage to read teh xml and write them to datasets. I was using External Source Stage to read the xml by specifying URL as input column content. It was working fine till now. Today when i run it, I did not get any records as output. The job shows as completed in Di...

Hi Guys, Could you please help on the following issue. while doing the look up, for the unmatched records in one of the column (ODBC stage timestamp data type) I am getting the ******************* value. But my target column is oracle databse timestamp. I couldn't understand why I am getting *******...

Hi Guys, Good morning. I am having the issue unmatched records with lookup stage. For unmatched records datastage populating zeros in the fields but one of my traget field (oracle database) is timestamp. because of this job is aborting. Could you please help me handing zeros in the timestamp format ...

Hi, I am trying to capture the empty spaces and default them to null. So may i have to use a transforemr after teh XML Input and do something like IF input.columnname ='' then setnull() else input.columname. I think i will try this. when i checked Replace empty spaces with null, i did not get even a...

They are empty. I can see that they are empty when i view tthe particular XML file.


reddy

Can you please tell me the solution for this problem? Thanks.


Reddy

Hi,

I am trying to replace the Empty values in the xml files to null. I have checked Replace Empty values with Null tab both on Stage/Transformation settings and Output/Transformation settings page. But i see empty values in teh output. Can anyone please help me? Thank you.

Reddy

I am able to convert 01/01/2008 to 2008-01-01 00:00:00 but surprisingly it returns ******* for 01/25/2008. Can anyone explain? Thanks.

reddy

I am able to convert 01/01/2008 to 2008-01-01 00:00:00 but surprisingly it returns ******* for 01/25/2008. Can anyone explain? Thanks.

reddy

Hi,

I have a datefield (01/25/2008) stored as a Varchar. I need to convert it into Timestamp 19 format with hh:mm:ss as 00:00:00. I went through different threads and tried different things. Everytime i get ***** as out put. Can anyone please help me? Thanks in advance.


Reddy.

Hi, I have used the External Source Stage. I can see that the records passed through to XML Input stage but, all the records are rejected and none of them are processed further. I used a peek stage and got the following error message. "Peek_5,0: Reject:XML input document parsing failed. Reason:...

Hi Guys,

One of my job aborting after 50 warnings when I run in the job sequence.
Could you please help me on how to avoid the warnings limit.
I appreciate your help and time.
Regards
Narasa