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 |
To import the flat file definition into the designer where should the flat file be placed?
When you move from devel to prod how will you retain a variable
What are the various types of transformation?
What are junk dimensions?
what are the challenge face in u r project?explain me
Types of error logs in Informatica?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
how to join the 2 different table with different columns in informatica?
what is diff between grep and find
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
what is the need of session partitioning... how it is useful in real time