Single “Filler” Field Flat File vs Multiple Fields Defined Flat File

20 pts.
Tags:
Flat files
What are the Pros and Cons of using a Flat File with a single large field defined compared to a Flat file with multiple defined fields? For example: Physical File: TESTFILE1 R TESTFILE FIELDA 50 Physical File: TESTFILE2 R TESTFILE DEFINED1 20 DEFINED2 10 DEFINED3 5 DEFINED4 15

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

If you have fields defined, then it’s not really a “flat” file anymore. I can’t honestly think of what you gain or lose by doing this, unless you’re going to define the file completely with every possible field.

If you need to access data in position 2-3 and you don’t have that position defined as a field, then you will still need to define a subfield or substring of the data.

Regards,

Martin Gilbert.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following