Interested to Buy Any Domain ? << Click Here >> for more details...
Which is better performance wise database or file?How?
- 2 Answers
- 6703 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 |
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
what is normalization? explain 1st NF, 2nd NF, 3rd NF
what is normalizer transformation?
How can you validate all mappings in the repository simultaneously?
how can i invoke pmcmd in command line prompt
How to generate or load values in to the target table based on a column value using informatica etl tool.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How many repositories can we create in Informatica??
how to load dimension table and fact table. plz tell me the steps.
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
Which gives the more performance when compare to fixed width and delimited file ? and why?
Target increases every day even though no new record was inserted
Teradata 
