File to file scenario-One file from sender system and four files an target system using csv file

[Former Member]

Hi All,

I have following scenario, experts need you help.

In the input file we can have records for different companies like wipro, capgemini, infosys and have valid an invalid records

Sender structure:-

--------------------------

companyId,empname,salary

Receiver Structure:-

---------------------------

companyName,empname,salary

--> apart of 1001, 1002, 1003 it should move to errorfile)

Input file:-

------------------------------------------------------------

1001,rama,2000

1001,kiran,8000
1002,ravi,3000

1002,madhu,9000
1003,ramu,4000

1003,mahi,4000
10,hari,5000

Output:-

------------------------------------------------------------

File1 : with all wipro employees
File 2 : with all capgemini employees
File 3 : with all infosys employees
File 4 : Error records

Example:-

-------------------------------------------------------------

wipro.txt
wipro,rama,2000

wipro,kiran,8000

capgemini.txt
capgemini,ravi,3000

capgemini,madhu,9000

infosys.txt
infosys,ramu,4000

infosys,mahi,4000

errorfile.txt
errorfile,hari,500

How design is possible with single target data type and single receiver determination. Can you please explore how and provide me design. However just explain steps and features to achieve this.

Can you please help on this.

Thanks,
Rama.

[Former Member]

Hello,

There are two options either use multimapping (as shown below) and under one mapping define conditions to create 4 different files or simply create 4 different mappings and at Interface determination call 4 operation mappings (3 for different company codes + 1 for error records) with a condition.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90dcc6f4-0829-2d10-b0b2-c892473f1...

Thanks

Amit Srivastava