Interested to Buy Any Domain ? << Click Here >> for more details...
Which is better performance wise database or file?How?
- 2 Answers
- 6560 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 is status code in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How you can differentiate between connected lookup and unconnected lookup?
What is a sorter transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
What is a pre-defined event and user-defined event?
In which circumstances that informatica server creates Reject files?
can you avoid static cache in the lookup transformation? I mean can you
How do you manage the Parameter files while migrating your data from one environment to another environment?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
How will you update the first four rows and insert next four rows in a mapping?
Teradata 
