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

Answers were Sorted based on User's Feedback



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

Answer / murthy

fixed width,because there are no delimiters to check so the
preformance will increase

Is This Answer Correct ?    18 Yes 3 No

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

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

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

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

Post New Answer

More Informatica Interview Questions

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.

3 Answers   TCS,


WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,


Enlist the advantages of informatica.

0 Answers  


2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,


wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,






What are the data movement modes in informatcia?

3 Answers  


What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  


What is the way to execute pl/sql script using informatica mapping?

0 Answers  


Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,


define galaxy repository in informatica

0 Answers  


In development project what is the process to follow for an etl developer from day1

0 Answers  


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  


Categories