Mapping logic

[Former Member]

Hello

Am new to mapping logic in PI.

I have a source structure as

Product A has part 1 and part 2 associated with it

Product B has part 3 and part 4 asosciated with it.

ques: proxy to jdbc scneario.

1) How should the source structure be : flat or tiered?

Product

Part

or

Product

Part

Part might have more info associated with it : lets assume partdetails1 ,partdetails2

Product and part can be repeating segments.

2) target is a database table

each record should have Product ,part and part details associated.

eg : Product A , Part1 ,Part1details

Product A , Part2 ,Part2 details

ProductB , Part3 ,Part3 details

Product B ,Part4 ,Part 4 details.

Can someone suggest how to do mapping for this ? i understand some node functions will be required..

Thanks

[Former Member]

Hi,

We can use node functions to do this. Can you give your source structure for this so that somebody can give you the logic?

Regards,

---Satish