Which is better performance wise database or file?How?
Answers were Sorted based on User's Feedback
files are better in performance than database.
because database has to connect to the odbc,and some drivers to extract or load the data.
But in case of file we directly extract or load the data.so,as per the performance files are better
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What are some examples of informatica etl programs?
permutations of mapplet
Can you copy the batches?
task is running successfully but data is not loded why?
What is diff joiner and lookup
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
How to load a relational source into file taget?
What is the capacity of power cube?
normalizer transformation
what is the mechanism of the Master-Detail joining condition?
when we dont use aggregator in mapping ?
How to handle changing source file counts in a mapping?