Which is better performance wise database or file?How?
- 2 Answers
- 6062 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
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 |
Post New Answer View All Answers
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
what is size of u r database?
What is the meaning of up gradation of repository?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the different ways to implement parallel processing in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is lookup transformation?
What is workflow monitor?
What are different types of transformations available in informatica?
Explain the etl program with few examples.
What is the surrogate key?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
What do you mean by filter transformation?
