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 |
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
How to create Target definition for flat files?
Performance wise which is better joiner or look up ? Give me with example?
How to generate a single mapping for both the historical and incremental load.
How to delete duplicate row using informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is mapping debugger?
How to eliminate duplicates in FF and oracle both
Which are the different editions of informatica powercenter that are available?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What is the use of an aggregator cache file?
what is correlated query?