How to convert flat file into xml file? How to tune joiner?

Question

Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

Answer 1

Follow the below stepd to tune the joiner t/r:

1. select sort input and make sure that you send the sorted data.
2. try to use normal join and master join than full and detail join.
3. try to mark the master table which has less no.of rows