File - File Multimapping(1 File to be Split into N no of Files)

[Former Member]

Hi

I have FILE 2 FILE Scenario.

Requirement is to convert source xml file to n no of files.

eg If we have 3 records in a source file , the target must have 3 files  added with timestamp.

[Muniyappan]

Since it is xml in the source i think you have to use multimapping. for having filename in the target based on the number of records like 1,2,3, you need to use UDF/std function to generate the number and map it to target.at the end use variable substitution.

but this is going to have extra field on the target side.

else you have to use below approach to make use of DC.

[Harish]

Hi Ziaur,

The best way is set recordset per message to 1 in FCC. refer the below blog

regards,

Harish

[former_member190624]

Hi Ziaur,

Yes , we can do this in 2 ways,

1. Using  File content conversion (FCC) in sender communication channel .

2. In message Mapping , change Target side  occurrence to 0 to unbounded.

Thanks

Hari.

[Former Member]

Hi Hari

I have XML file so no FCC.

Regards,

Ziaur

[former_member190624]

Hi Ziaur,

This will be done through multi-mapping , just change the occurrence of the message mapping target structure and Operation mapping structure as shown below ,

Message Mapping :

then your message will look like as below ,

Map Messages and Messages1 with constant and make sure MT_* (your message type structure will repeat as per your requirement ). And Test with sample XML and you should get multiple MT_* segment in target .

Operation Mapping :

Note : While doing end to end testing , no need to mention messages and message1 segment in Source XML file.

Thanks

Hari.