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
How you can differentiate between connected lookup and unconnected lookup?
Why do we need informatica?
expain about the tune parameters?
What is rank transformation in informatica
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are junk dimensions?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
what is size of u r database?
tell me about your project functionality
Informatica Checkpoints
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is meant by lookup transformation? Explain the types of lookup transformation?
What is standalone command task?
How to handle decimal places while importing a flatfile into informatica?