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

Answer Posted / murthy

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

Is This Answer Correct ?    18 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

To import the flat file definition into the designer where should the flat file be placed?

673


What is dimensional table?

617


Does an informatica transformation support only aggregate expressions?

606


How to convert multiple rows to single row (multiple columns) in informatica

890


Design a mapping to load the cumulative sum of salaries of employees into target table?

889






What do you mean by worklet?

624


Explain what is informatica metadata and where is it stored?

605


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1027


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5780


What is fact table? Explain the different kinds of facts.

611


What is the difference between informatics 7x and 8x and what is latest version?

540


What is informatica etl tool?

548


Under what conditions selecting sorted input in aggregator will still not boost session performance?

630


What is sorter transformation?

579


Suppose we do not group by on any ports of the aggregator what will be the output?

568