Complex File Processing - 0 to 60

The Complex File technology adds a powerful new driver into the ODI capabilities. It leverages the Fusion Middleware capabilities for supporting complex files, you can then build ODI interfaces just as you are used to!

Using an example from the Oracle┬« Fusion Middleware User's Guide for Technology Adapters 11g Release 1 (see here), the viewlet quickly builds up the model based on the XSD for the complex file (use Native Format Builder to construct).

 Have a look at the viewlet right here

http://blogs.oracle.com/dataintegration/resource/viewlets/odi_11_complexfile_viewlet_swf.html

You can pause it to catch your breath! Its condensed into 60 seconds to keep your attention.

Comments:

I forgot to mention there is a write up in the blog below of an example from beginning (getting JDev) to end;
http://blogs.oracle.com/bwb/resource/2011-02-22/SOA_Suite_11g_Native_Format_Build_Complex_Format_Example_FullPost.html

Cheers
David

Posted by David on June 15, 2011 at 07:37 AM PDT #

Complex File Processing

I understand that ODI has the abilety to manipulate complex file structure using the Native format builder. The "complex file definition" as it stands is: one row in the file may contain Buyer,Seller... information.What im an faced with here is more of a file structure where each row based on the flag in the first position can mean heit different things necesseting 8 parsing structures. After reading many blogs and documents i am not sure ODI Native format builder can do this ?

EX:
110000395316400004739000000020000003185203091879102231776RP0001000000000000000180000000000000000000000000101000000000000000000000000000000000018608020000001016600187800000010000000000000000001500000001853100000014180018510000000000000000000
21000039534185318520000000000000000001418530300000000000000000000241853185200047390002008020018185314000000000001800185109718531852999901500500000000211852185401000000003000001663000000000186018600000000T031185418540101860000500090260000000
21000039533018600000186000000000000T0311855185701037200001000004663018601860186018600000000I0311857185801037200005000004663018601860186018600000000T0311859186001037200005000004663018601860186018600000000I031186118620103720000500000466000000
21000039533018601860186018600000000I0311863186401037200005000004663018601860186018600000000I0311865186601037200005000004663018601860186018600000000I0311867186801037200005000004663018601860186018600000000I031186918700103120000500000466000000
210000395320060006000000000000000000003015601560186018603003000I03118711874010000000010000156620340034600000000000000000003000000000186018618618600I03118731876010106000040000046620258027400000000000000000003005700490186018612913700I03000000
2100003953118751878010028000050000026620310036300000000000000000003002800000186018615818600I03118771878010048000050000026620275036300000000000000000003004800000186018613818600I0300000000000000000000000000000000000000000000000000000000000000
210000395300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001
210000395318529999015005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001010000000000000000000000000000000000000000000003
5100003953371852190300000000000000000000000000000000000000000000000000000001852021003284000000000009000000000000000190300100009444000001879003284000000000000000000001770000A0000000000000000000000000000000000000000000000000000000000000000000

Each line is fixed length 240
pos:1 = flag that tels you what information is contained. For each flag = different parsing.

I am trying to stay away from scripting this :)

Posted by Charles Baumann on July 19, 2013 at 10:30 AM PDT #

Hi Charles

You can either use the multi-record fixed length file approach if your data fits that, or build a custom complex file. It sounds like the multi-record fixed length file works for your data?

Cheers
David

Posted by David on July 19, 2013 at 01:44 PM PDT #

If you want to create records within the row, then that can be done with the complex type approach.

Posted by David on July 19, 2013 at 02:04 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today