Forum Stats

  • 3,827,921 Users
  • 2,260,839 Discussions
  • 7,897,407 Comments

Discussions

How to handle Unstructured Text file in ODI ?

I have a text file having this kind of data

REC_CODE ORDER_ID    CUSTOMER_ID   ORDER_DATE

ORD  1     1 01-01-2001

LIN 1   1    1 1

LIN    1 2 2   3

LIN   1 3  1   2

ORD 2 3    02-01-2001

LIN      2 1 1 1

LIN 2    2 2 3

LIN 2   3 1   2

If you see this data carefully ORD corresponds to the Order Level details where as LIN corresponds to Line details of the Order, The problem is the file is not delimited or having fixed width this varies as you can see there are single space and multiple spaces in file.

Any suggestions on handling this in ODI to import the data and process it ? I tried File technology for this since it is unstructured i was not able to get through the first step.

Tagged:
This discussion has been closed.