DSXchange

Hi Ernie, Thanks for your response. This way it is mentioned in XSD. <xsd:element name="ETCof"> <xsd:complexType> <xsd:sequence> <xsd:element ref="TrxnTyp"/> <xsd:element ref="TrxnTypDtl"/> <xsd:element ref="CntbWdCode" minOccurs="0"/> <xsd:element r...

The output result should come like this. Expected Result: ProcessDate|FundAcctID|DlrAcctID|RepCode|FundID|GrossAmt|UnitTrxnd|AveCost 20140702|26204388|543080691|AAA|266|0|0|0 20140702|26204388|543080691|AAA|568|21180.08|1650.748|0 20140702|26204388|543080691|AAA|590|11394.67|574.876|0 20140702|26204...

Hi Michael, I am doing the same steps in my job, and but I am getting only the first TransfrID values(FundID,GrossAmt,UnitTrxnd,AveCost) coming in output.For the other TransferID details should come in a different row in same column (FundID,GrossAmt,UnitTrxnd and AveCost) with the parent values i.e....

Hi Ray,

Thanks for your response. Yes, I am trying to read this type of XML file and want to create multiple rows based on the number of TransferFund sections coming in the XML file.

Hi All, Below its a sample transaction record that I am trying to process in XML stage. There can be multiple TransferFund under one traansaction, when more than one TransferFund are coming then the detila inside the trasnfer fund should come in a new row with the Parent Tag Values. Could you please...

Hi All, I need to process some XML files having the same metadata definitions. There are three XSDs were used to define the metadata of these XML files. The Reconciliation.xsd is the main XSD from where I am able to read most of the fields coming in XML file. But the main XSD is having include state...

I need to use it for filtering the incoming records and that is why I am using in the transformer constraint.

Even I have tried with this logic as well but the same error I am getting again. (TRIM(NulltoValue(DSLink110.TrxnTyp,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl,''))=4) Or (TRIM(NulltoValue(DSLink110.TrxnTyp_2,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_2,''))=4) Or (TRIM(NulltoValue(DSLin...

Ya I know there are some null values are there, that is why I am using IsNotNull(TrxnTyp) in the condition.

Hi, I am using the below logic in transformer as filter condition and getting the error message as "Fatal Error: Null value on the accessor interfacing to field "TrxnTyp". (IsNotNull(DSLink110.TrxnTyp) and IsNotNull(DSLink110.TrxnTypDtl) and (TRIM(DSLink110.TrxnTyp)=5 and TRIM(DSLink1...

Sampple XML: <?xml version="1.0" encoding="UTF-8"?> <TrxnRecon xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="nsrt" xsi:schemaLocation="nsrt Reconciliation.xsd" Version="24"> <CreateDate>20140521</CreateDate> <MgmtCode>UN6</M...

I have taken the premium membership for one month, but still I am not able to see the content, even after follow up also I am not getting any reply from them. Invoice# 0000002805 Invoice Date: 06/12/2014 03:00:45 Items Qty Item # Description Price Each Total 1 1 Month Premium DSXchange 1 Month Premi...

It's probably a list mapping issue. Look at your xsd as loaded into the Assembly. One place you can do this is in beginning of the xml Parser step where you selected your document root. Open up ... I am not able to see the full content, could you please send the details in my mail id, if possible, ...

1)In extenal source stage I am using this command which will read the file staring with TST. ls /app/DEV_SET0/Temp/TST This command is giving the list of files with path. 2)The in XML stage in XML parser step I am using file set option to read the filepath which I have selected from the drop down li...

I have a job like the following. 1. External source stage to read the xml file path. 2. Parsing the xml by using new xml stage in datastage 8.5. 3. Write the parsing records into one file. But here I am getting only one output record, though there are number of records in the XML file. Is there anyt...