PFI and Data Transformation

First if you have no training on PFI, I would suggest to get one (Lawson is offering a course on Integration Solutions). Next most transformation engine used by LSF9 processflow is DatastageTX7.5 by Ascential. You can also create a cobol program to transform your data before importing to Lawson.
Actually as the saying goes, "There's a lot of ways to skin a cat".

You should definitely check out IBM/Ascential DataStage (previously Mercator) which you will need to use for any serious data transformation.

Be sure to check out the content/articles on https://www.lawsonguru.co...ProcessFlowBCI.aspx, which includes my on-going LawsonGuru Letter series on ProcessFlow Integrator.

We had on site training but the instructor did not go over some of the advanced options. We have the IBM/Ascentia product instaled but we are trying to figure out out to use it with PFI. Do you know if there are any good docs or advanced training that may be availble for this?

Here's an example of how you integrate data mapping(DatastageTX) with PFI: I'm assuming that you have the client copy of your Ascential product):
1. Make a type tree for both input and output: Field by field definitions
2. Create the MAP : from what field (input) to what field (output)
3. Create a map object depending of what platforms ... windows, aix etc then upload the object to the server.
4. Create a process flow : Use the TXAdapter node to pass the name of your input file and the name of the map uploaded to the server.

Thanks for the feedback. I will give it a try.