n:1 multimapping for multiple records in every file

[Former Member]

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?

Regards,

Shabari

[Former Member]

Please check the below blog

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/10526

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.

[former_member415468]

Hi Shabari,

Plz check the below link

http://www.saptechnical.com/Tutorials/XI/BPM/Fork1.htm

Regards

Muni