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
- 13754 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the reusable transformation?
What does command task mean?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Design a mapping to load a target table with the following values from the above source?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to load data in informatica ?
What are the different transaction levels available in transaction control transformation?
Differentiate between source qualifier and filter transformation?
Scheduling properties,whats the default (sequential)
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Performance tuning in UNIX for informatica mappings?
What is the difference between informatica 7.0 and 8.0?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Why do you use Mapping Parameter and mapping variable?
