Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
How to handle Unstructured Text file in ODI ?

3408387
Member Posts: 40
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.