OraFAQ Forum: Client Tools » what exactly is a complex flat file?

Home » Other » Client Tools » what exactly is a complex flat file?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what exactly is a complex flat file? [message #327086]

Fri, 13 June 2008 13:17

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?

Report message to a moderator

Re: what exactly is a complex flat file? [message #327088 is a reply to message #327086]

Fri, 13 June 2008 13:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Where do you read or hear that?

Regards
Michel

Report message to a moderator

Re: what exactly is a complex flat file? [message #327089 is a reply to message #327086]

Fri, 13 June 2008 13:26

BlackSwan
Messages: 26766
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!

Report message to a moderator

Re: what exactly is a complex flat file? [message #329015 is a reply to message #327086]

Mon, 23 June 2008 13:46

Kevin Meade
Messages: 2103
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

Report message to a moderator

Re: what exactly is a complex flat file? [message #329019 is a reply to message #327086]

Mon, 23 June 2008 13:56

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: what exactly is a complex flat file? [message #329021 is a reply to message #327086]

Mon, 23 June 2008 14:01

Kevin Meade
Messages: 2103
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

Report message to a moderator

Re: what exactly is a complex flat file? [message #330183 is a reply to message #327086]

Fri, 27 June 2008 16:09

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 15:47:04 CST 2024