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
- 13913 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / koti
surely fixed width gives best performance. because it need
not to check each and every time where the delimeter is
taking place.
| Is This Answer Correct ? | 2 Yes | 3 No |
waht is dataware house
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
how do u fnd the duplicate rows and how to delete the duplicate rows?
How can you display only hidden files in UNIX
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain pushdown optimization and types in informatica
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
what is shared Cache. when we will use shared Cache?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
how to identify new and old values in source qualifier or any other transformations using informatica
Design a mapping to load a target table with the following values from the above source?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
Teradata 
