Skip to Content
avatar image
Former Member

Handling Complex Structure using FCC to generate Flat File

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 24, 2009 at 09:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 24, 2009 at 09:50 AM

    Hi,

    This may help you..

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

    Regards,

    Sarvesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 24, 2009 at 10:21 AM
    Add comment
    10|10000 characters needed characters exceeded