Which is better performance wise database or file?How?
- 2 Answers
- 5724 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 |
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
What are variable ports and list two situations when they can be used?
What are the types of metadata that stores in repository?
If u select groupby port in aggregator what is output and dont select groupby option what is output
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
How to recover sessions in concurrent batches?
what is the difference between static and dynamic
Why should we use star schema in datawarehouse design?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
explain about unit testing? in real time?
Teradata 
