Which is better performance wise database or file?How?
- 2 Answers
- 5952 Views
- TCS, I also Faced
- E-Mail Answers
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 active transformations? Name them.
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
Can we update the data in flat file using update strategy?
What is the difference between a table and the materialized view?
What is confirmed fact in dataware housing?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
what is informatica metadata?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
How to load a Dimension ? and how to load a fact table?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
What are teh different tasks that can be created in workflow manager?
Teradata 
