Which is better performance wise database or file?How?

Answer Posted / gyana

flat files are good for performance....
but fixed width files are more better than a delimited flat file......

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we use batches?

811


Explain informatica architecture - version 8 / 9

876


Mention few advantages of router transformation over filter transformation.

865


Which transformation is needed while using the Cobol sources as source definitions?

978


how to load dimension table and fact table. plz tell me the steps.

1890


How is union transformation utilized?

806


How can we remove the duplicates from flat file source?

817


Explain the shared cache and re-cache?

856


How to improve the performance of a session using sorter transformation?

945


Difference between Data and Index Caches?

906


Explain dynamic target flat file name generation in informatica

876


How to start a workflow using pmcmd command?

963


What are the popular informatica products?

823


What is data movement mode in Informatica and difference between them?

884


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1453