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 |
how to load rows into fact table in data warehouse
What is critical mapping?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Diff b/w ShortCut and reusabel Object ?
What is the cumulative sum and moving sum?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What are the active and passive transforamtions?
what is the difference between repository & Intergration service
what is the method of error handling when session is running?
What is a snowflake schema?
what are the limitations of pushdown optimization technique ? Advance thanks
What are limitations of joiner transformation?