on 03-24-2009 9:30 AM
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"?>
<ns0:MTO_Customer_Details_Axis xmlns:ns0="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
Gaurav,
FCC cannot generate flat files beyond 3 lervels
/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi ,
Kindly refer to this link..
http://www.riyaz.net/blog/xipi-file-content-conversion-for-complex-structures/
May help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This may help you..
/people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.