cancel
Showing results for 
Search instead for 
Did you mean: 

Handling Complex Structure using FCC to generate Flat File

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member206760
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos
Former Member
0 Kudos

Hi,

This may help you..

/people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure

Regards,

Sarvesh