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 |
What did you do in source pre load stored procedure
If we are using an aggregator but forget to mention the group by port .what will be the output??
How identifying bottlenecks in various components of informatica and resolving them?
How to compare Source and Target table, without using dynamic lookup?
what is session parameters?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
what is data driven?
How can yoU improve session performance in aggregator transformation?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve