Which gives the more performance when compare to fixed
width and delimited file ? and why?
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 |
without matching columns in two tables. how can you join
If you want to create indexes after the load process which transformation you choose?
4 yrs etl devloper roles and responsibilities?any body give solutions
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
What are the differences between joiner transformation and source qualifier transformation?
What are the reusable transforamtions?
How to load a relational source into file taget?
In session log thier should not be a single error how will u do
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
What will be the approach?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?