Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - Which gives the more performance when compare to fixed width and delimited file ? and why?




771
views
asked marvit September 20, 2014 08:02 AM  

Which gives the more performance when compare to fixed width and delimited file ? and why?


           

1 Answers



 
answered By vishnoiprem   0  
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.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert