Skip to Content
0
Jun 28, 2011 at 12:51 PM

Mapping problem

24 Views

Hi All

Scenario is JDBC to File

Requirement is:

Pick up a records from two tables.

1st table is Header table and 2nd table is Details table.

Both tables are having Bill_NO

2nd table also contains Line_Item_No

Now,

Through SQL query I am picking up 3 records each time.

Problem I am facing in Mapping

for 1st record I have created Target Header segment and under header produced details segment having Line_Item_No

for 2nd record also I have created separate Header segment and under header produced details segment having Line_Item_No

now 3rd record Bill_No is similar to 2nd record but diff Line_Item_No

now for this I dont want to repeat header I just want to repeat Line_Item_No under previously header segment.

Is this requiremt possible. If yes then which logic i can apply, i am relly confused.

header bill no................................details bill no..line item no
3a1OTHR000684	022	HARISH  KUMAR     	3a1OTHR000684	2	022
3a1OTHR000686	022	AMIT KUMAR  GAUR	3a1OTHR000686	2	022
3a1OTHR000686	022	AMIT KUMAR  GAUR	3a1OTHR000686	3	022

022 is organization code

Regards

Dheeraj Kumar