Interested to Buy Any Domain ? << Click Here >> for more details...
Which gives the more performance when compare to fixed
width and delimited file ? and why?
- 3 Answers
- 13570 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / ams
It all depends on data and what you are ultimately doing
with that data. Any consumer of that data will ultimately
want to break down that data into fields. During the break
down of those fields, you will need to check for a maximum
field size as you read through the data stream.
So if you have an 80 character fixed width field, you will
ultimately have 80 comparisons to see if you have reached
the field max.
Delimited break down of data requires not only a check for
the field max, but also a check for the end of field
delimiter.
So if your delimited field is only 20 characters long, you
will have only 40 comparisons made across those 20
characters you just processed.
So, the more padding you have in your fields, the less
efficient fixed width becomes when processing.
An additional factor is actual bytes that are necessary to
be transmitted. In almost all cases, delimited will
require less character having to be transmitted.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is informatica etl tool?
What is sq transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Which means the first record should come as last record and last record should come as first record and load into the target file?
Enlist the various types of transformations.
Mention a few design and development best practices for informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is a transaction control transformation?
What is source qualifier transformation in informatica?
How we can create indexes after completing the load process?
Explain the different lookup methods used in informatica?
What is event and what are the tasks related to it?
How to generate sequence numbers using expression transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
