cancel
Showing results for 
Search instead for 
Did you mean: 

FCC for multi Hierarchical structure in SFTP receiver

former_member235717
Participant
0 Kudos

Hello experts,

Could someone help me out in this. Below is the source hierarchy

Level1                       - 1

    element1

    element2

    element3

    Level2                    - 0 - unbounded

         element1

         element2

         element3

               Level3         - 0 - unbounded

                     element1

                     element2

                     element3

and the result shout be a flat file with the following format

Level1-element1   level1-element2  level1-element3

Level2-element1   level2-element2  level2-element3

Level3-element1   level3-element2  level3-element3

The fields are of fixed lengths

I have refereed the below link but the flat file format is not similar to the one I'm expecting.

FCC For Hierarchical Structure in Receiver Channel - Process Integration - SCN Wiki

Could someone please help me on the SFTP content conversion for the above format

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

former_member182412
Active Contributor
0 Kudos

Hi Swetha,

You can create flat target structure like below for your source deep structure.

Level1            - 1

    element1

    element2

    element3

Level2          - 0 - unbounded

    element1

    element2

    element3

Level3         - 0 - unbounded

    element1

    element2

    element3

And do the normal FCC configuration, in the message mapping you can con convert from deep structure to flat structure.

Regards,

Praveen.

former_member235717
Participant
0 Kudos

But in my requirement the target structure (Receiver) is also created as below data type

Level1                       - 1

    element1

    element2

    element3

    Level2                    - 0 - unbounded

         element1

         element2

         element3

               Level3         - 0 - unbounded

                     element1

                     element2

                     element3

As per your suggestions, doesn't it effect the data flow?

former_member182412
Active Contributor
0 Kudos

Hi Swetha,

Yes create the data type as i suggested above then it will be easy to do the FCC configurations. With in the mapping you can do the transformation between deep structure to flat structure.

Regards,

Praveen.

former_member235717
Participant
0 Kudos

Thank you Praveen,

For the mapping - does the regular graphical mapping helps or do I need to go for Java mapping or XSLT mapping?

I tried to research and found more blogs suggesting for XSLT or java mapping

former_member182412
Active Contributor
0 Kudos

Hi Swetha,

You can do this using graphical mapping no need for java mapping.

Regards,

Praveen.

former_member235717
Participant
0 Kudos

Thanks for the quick response.

former_member235717
Participant
0 Kudos

Hello Praveen,

I have built the target structure as specified but when I'm testing with multiple nodes from source:

Level1                       - 1

    element1

    element2

    element3

    Level2                    - 0 - unbounded

         element1

         element2

         element3

               Level3         - 0 - unbounded

                     element1

                     element2

                     element3

    Level2                    - 0 - unbounded

         element1

         element2

         element3

               Level3         - 0 - unbounded

                     element1

                     element2

                     element3

I'm supposed to get the target as

Level1

Level2

Level3

Level2

Level3

but now I'm getting as

Level1

Level2

Level2

Level3

Level3

Could you please help on this

former_member182412
Active Contributor
0 Kudos

Hi Swetha,

You can add another root node for your target structure.

     Level1            - 1

         element1

         element2

         element3

     Item               0 - unbounded

          Level2          - 0 - unbounded

              element1

              element2

              element3

          Level3         - 0 - unbounded

              element1

              element2

              element3

And in the mapping you need to generate the output like below.

Level1

Item

     Level2

     Level3

Item

     Level2

     Level3

Then you will get required output, but dont mention Item node in the FCC configuration in receiver channel. Just mention only Level1, Level2 and Level3 what you have configured currently.

Regards,

Praveen.

Answers (0)