Skip to Content
0
Former Member
Dec 08, 2011 at 03:58 PM

node mapping

39 Views

hi guys,

i have a source(flatfile) which looks like follow:

note:number of XYZ in a ABC node will be same throughtout for 50 ABC.

ABC|1234 | (0-50 --Parentnode)

XYZ|A| (0-unbounded ---Childnode)

XYZ|V|

XYZ|K|

ABC|5678| (0-50 --Parentnode)

XYZ|L| (0-unbounded ---Childnode)

XYZ|H|

XYZ|G|

.

.

.

.

And the target side structure(xsd) is follows:

customer------mainnode(record)

book

pen

value------child node

V----


child of value

..................................................................................................................

my requirement is, i have to create multiple Customer records based on number of XYZ present in a ABC node.like 3 as above.

And second thing is "value" should create based on number of ABC.like 2 as above.

third one is under each value node first "V" should get the value of first XYZ of first ABC and second "V" should get the value of first XYZ of second ABC.

..................................................................................................................................................

the output should look like :

Customer

book

pen

value

V

value

V

Customer

book

pen

value

V

value

V

Customer

book

pen

value

V

value

V