Showing results for 
Search instead for 
Did you mean: 

n:1 multimapping for multiple records in every file

Former Member
0 Kudos

Hi ,

I am merging 2 files into a single file. First file has employee personal data and second file has employee salary data.I have created BPM and used correlation on EmpNumber to merge both the files. In BPM I am using fork step to recieve two files then use Transform step to merge the files and finally send dtep to send the output file.

If both the input files have single employee record my scenario works fine. However my requirenment is file one will have 10 employee records . File two will have salary details of the same 10 employees . I have to merge both the files and create 10 final records of employees .

Here i am not able to use correlation as i dont have unique key in the file.

Can any one tell me how to achive this?



Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Please check the below blog

Refer the blog for the BPM design. You can make changes such that you include a fork(with two branches)inside the loop. But without correlation how will you merge similar employee records.

0 Kudos

Hi Shabari,

Plz check the below link