Split Denormalized Flat Files into 2 Files
I am trying to build an OIC integration that process a flat file from FTP. That file is a denormalized file. For example, order header fields and line fields are on the same line. If there is multiple lines, header fields will repeat on the 2nd lines, 3rd lines, etc.
However, there are a few key fields. I have to use those key fields to determine the uniqueness of header. The target output is 2 flat files. 1 is the header level and the other is the line level. How to achieve that in OIC? Any thoughts on it?