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 are the different options available for update strategy?
Explain pushdown optimization and types in informatica
What all are steps in up gradation of Informatica server?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
what is the size of your data warehousing?
What do you mean by worklet?
Explain in detail about scd type 1 through mapping.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Write the unconnected lookup syntax?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
If informatica has its scheduler why using third party scheduler?
Enlist the various types of transformations.
How do you load unique records into one target table and duplicate records into a different target table?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?