DSXchange

Hi all,

Newbie here.
Can you guys please help me out with a job design. Here are the details.

I have a fixed length file containing a lot of headers(journal) and details(journal). The header records are distinguished from the detail by a column( Has 'A' for header, blank for detail). I have to do a lookup on this file and based on the lookup have to do some transformations separately on the header and the detail and again load them to a same file. Can anyone please tell me the logic of how to achieve this( seperate transformations on header & detail). Sorry, if this is too simple of a question.

Let's assume you have a file:

Arndw,

sorry for the confusion.


The lookup altogether is against a different file based on key columns common to both headers and details. I need to do transformations separately on all headers (header1, header2.....) and all details (detail1.1,detail1.2..........) and load them to target in the same order as source file. please let me know if I am still confusing.

What you have provided is full flow with no detail. It leaves lots of questions like
1.) What column in source is used to fetch data?
2.) What value in the reference must match and what is returned ?
3.) Must that happen for all rows or only on specific condition?

Maybe you can try to work on it and provide the bits you find difficult.

As per my understanding of your requirement,,,

If you have seperate key columns in both source and reference files, you can do lookup based on that key columns and then in a transformer you can check for the column (which seperates header and details) . If that column equals A, then do calculation for header else do calculation for detail.

I hope you will get the records in same order as output. If not sort the records after source and preserve the sort order till the output stage