on 05-05-2016 1:56 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.