Which is better performance wise database or file?How?
Answer Posted / venkateshmalneni
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 |
Post New Answer View All Answers
What do think which one is the better joiner or look up?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How can one identify whether mapping is correct or not without connecting session?
What are multi-group transformations?
How to load last n records of file into target table - informatica
Briefly describe lookup transformation?
Enlist the advantages of informatica.
How to create the source and target database connections in server manager?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Why do we need informatica?
How to generate sequence numbers?
Differentiate between a repository server and a powerhouse?
What could be the possible resons of locks by user?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs