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
- 13905 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
Target increases every day even though no new record was inserted
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
What is target designer and target load order?
Write the program through which the records can be updated?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What do mean by local and global repository?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the types of caches in lookup?
How many types of sessions are there in informatica.please explain them?
Explain about cumulative Sum or moving sum?
whats the logic to load the lower level of granularity of data to fact table.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is joiner transformation in informatica?
What if the source is a flat-file?
How can we create index after completion of load process?
