Home » SQL & PL/SQL » Client Tools » what exactly is a complex flat file?
what exactly is a complex flat file? [message #327086] Fri, 13 June 2008 13:17 Go to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
can anyone please tell me what a complex flat file is,
in context of ETL, when we say the source is a
"complex flat file"...in what way is it different from a
normal flat file?
Re: what exactly is a complex flat file? [message #327088 is a reply to message #327086] Fri, 13 June 2008 13:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Where do you read or hear that?

Regards
Michel
Re: what exactly is a complex flat file? [message #327089 is a reply to message #327086] Fri, 13 June 2008 13:26 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Results 1 - 10 of about 151 for ETL "complex flat file"
GOOGLE is your friend, but only when you actually use it!
Re: what exactly is a complex flat file? [message #329015 is a reply to message #327086] Mon, 23 June 2008 13:46 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
anacedent, did you actually read any of these google pages? I did, and I didn't find anything that said COMPLEX FLAT FILE meant anything.

What was the URL of the web page from whence you got a formal definition for COMPLEX FLAT FILE please?

Kevin
Re: what exactly is a complex flat file? [message #329019 is a reply to message #327086] Mon, 23 June 2008 13:56 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://datawarehouse.ittoolbox.com/groups/technical-functional/ascential-l/usage-of-complex-flat-file-in-data-stage-2061283
Re: what exactly is a complex flat file? [message #329021 is a reply to message #327086] Mon, 23 June 2008 14:01 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
Thanks buddy, I get it, a COMPLEX FLAT FILE is anything not simple.

That means, it contains some kind of "object style" datatype (an array, multiple/variable record types, compressed data, etc.).

Think, "a file that won't load into excel".

Much appreciated, Kevin
Re: what exactly is a complex flat file? [message #330183 is a reply to message #327086] Fri, 27 June 2008 16:09 Go to previous message
coleing
Messages: 213
Registered: February 2008
Senior Member
Yes, probably more likely to be mainframe files in EBCDIC format, containing multiple data structures, and even varying data structures in the same logical field.

You will find it very difficult (if not pretty much impossible) to load these up without a file definition to work from.

Previous Topic: Oracle Migration WorkBench, MSAccess to Oracle 9i
Next Topic: PL/SQL Developer Debugging Hangs
Goto Forum:
  


Current Time: Sat Dec 03 00:58:33 CST 2016

Total time taken to generate the page: 0.09116 seconds