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
- 13746 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 |
what is dimension table?
How to join three sources using joiner?
what are the challenge face in u r project?explain me
In which scenario did you used pushdown optimization?
why dimenstion tables are denormalized in nature ?
Where is the cache stored in informatica?
what is the diff b/w cached and unchaed look ups
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
How can i send first half of the records to one target and Remaining to other target?
What do you mean by filter transformation?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Teradata 
