Which gives the more performance when compare to fixed
width and delimited file ? and why?
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
Differentiate between source qualifier and filter transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
tell me about your project functionality
What is the advantage of informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is dynamic cache?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is Session and Batches?
What are mapplets? How is it different from a Reusable Transformation?
What is the sql query overwrite in source qualifier in informatica
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
can u give example for factless fact table
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how