I solved the above mentioned problem. Thanks for that.
Onemore thing Ram!!!
Here is my flow structure:
dbJvSokiOps:SelectJvSokiHdr (Select The Header Records From KSU_STARS_SOKI_JV_HDR)
dbJvSokiOps:SelectJvSokiDetails (Select The Detail Records From KSU_STARS_SOKI_JV_DETAIL)
SEQUENCE (Exit On Success)
SEQUENCE(Exit on Failure)
LOOP over /SelectJvSokiHdrOutput/results
Map Header Data to IDATA
LOOP over /SelectJvSokiDetailsOutput/results
Map Detail Data to IDATA
SEQUENCE (Exit On Done)
What I get is One header and One line again the same header and next different line. That means I have one header and two lines. I know I am not Looping it properly.
In my flat file I have FlatFileSchema Header as “H” and Line as “F” which is one level inside the header. Since I will have One haeder and multiple lines for that. So I have two queries one for header and another for details. I pass one of the primary key of header to details query as input and pull all the records for that primary key.
How can I get rid of the same header repeating?
Can you please help me out!!!