Hi All,
We are configuaring the Scenario from JDBC to File and the flat file need to be generate at the target end.We are facing the problem in generating the flat file as per the requirement. I am giving the structue of Flat File.
HDFC (Corporate Code)
HDFC BANK (Corporate Name)
CC (Product)
2,3,,1000,,123456,PROCESSED,,, (Transaction Description)
2,11,,6000,,245245,REJECTED,Rejected by user,,
DD
2,10,,2000,,1201212,PROCESSED,,,
21,,100000,,,REJECTED,Insufficient Fund,,
Above structure is the Flat file Structure which we need to generate and in the brackets i have mention the description of the section but it is not part of file.In that file product repeat multiple times and product can have have multiple transactions.For that i have the enclosing output of the mapping structure on which iam applying FCC(File content Conversion)
<?xml version="1.0" encoding="UTF-8"?>
http://corporate.com/essar_oil/reports">
<Record>
<CUSTOMER_CODE/>
<CUSTOMER_NAME/>
<PRODUCT_DETAILS>
<PRODUCT_NAME/>
<TRANSACTIONDETAILS>
<BATCH_ID/>
<TRANSACTION_ID/>
<FILE_NAME/>
<TRANSACTIONAL_AMOUNT/>
<VENDOR_TITLE/>
<TRANSACTIONAL_REF_NUM/>
<TRANSACTION_STATUS_CODE/>
<TEXT_DESCRIPTION1/>
<TEXT_DESCRIPTION2/>
<TEXT_DESCRIPTION3/>
</TRANSACTIONDETAILS>
</PRODUCT_DETAILS>
</Record>
</ns0:MTO_Customer_Details_Axis>
I am not able to achieve it due to complexity of the structure so, help me in acheving that.
Regards,
Gaurav Jindal