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 |
can we use bulk loading when we use look in mapping
Explain lookup transformation in informatica
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
what is diffrence b/w joner and union transfermation
How the facts will be loaded? explain
Enlist the differences between database and data warehouse.
What are the different clients of powercenter?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
when we use dynamic lookup,if condition matches what will be the o/p?
How many numbers of sessions can one group in batches?
Can we make worklet inside worklet?
How can you join two tables without any common column present in them?