cancel
Showing results for 
Search instead for 
Did you mean: 

Mulitple Detail record values in file adapter

Former Member
0 Kudos

Hi,

How shall I pick up a file in sender file adapter which is having two different record identifiers for their detail records. My structure is

Header - Record identifier is HDR

Detail - Record identifier is 10 and 30

Trailer - Record identifier is TRL

While configuring File adapetr I am unable to pick up Detail records with 30 because my Detail.KeyFieldvalue is only equals to 10. I know I can have a work around of picking up all the records and then in map distinguish all the different record types but I am interested in picking up all the detail records having different record identifiers.

thanks .

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Rakesh

Just an Idea..If you can make your source structure as

Header

Detail1

Detail2

Trailer

Then you can give Detail1 key as 10 and Detail2 Key as 30. I think its just matter of getting records and assigning to target structure, guess i think it might work

Just my 2 cents

Former Member
0 Kudos

Even I thought of this as one of my workaround but as we are close to GoLive I am seeking for some solution which I can handle it without changing my Design objects. So any idea in Configuration side?

Thanks.

Former Member
0 Kudos

I am afraid if thats possible. To my knowledge..i think you have to change in IR for sure