Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answers were Sorted based on User's Feedback
Answer / joe
In case of dbases- time is consumed to make the dbase
connection for reading/writing data to the table.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / suresh
Here the records has to pass through the database drivers and ODBC connections are required, which is a time taking process.
But where as records from flat files are copied in easier way
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nidhi
To write data in table informatica server generate the insert statement for each row where as for flat file write the data row wise in file.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ankur saini er.ankur861@gmail.
Hi in case of teradata..IS have to take care of database
logs , and backup tables etc like transient journel etc
which makes it slow in case of table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sanjay
While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.
Is This Answer Correct ? | 0 Yes | 0 No |
Thanks Rayudu.
Is there any other reson why flat file load is faster than
table load.
I had an interview and even I said the same answer. But the
interviewer asked me "Is there any other reason ?" .
Interviewer didn't satisfied with this answer.
I hope there will be some other reason as well for this
question.
Anyways thanks for your reply.
Is This Answer Correct ? | 0 Yes | 1 No |
Why is meant by direct and indirect loading options in sessions?
How will u pas the data with out debugger?
WHat all joins are there in Source Qualifier?
how can we calculate fact table size?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
How many number of sessions can one group in batches?
what is incremental aggregation ,with example?
What is a pre-defined event and user-defined event?
What is confirmed fact in dataware housing?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic