Interested to Buy Any Domain ? << Click Here >> for more details...
Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 18984 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What does cheating measurement mean?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
In informatica workflow manager, how many repositories can be created?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the advantages of using informatica as an etl tool over teradata?
How to Create a folder using pmrep command?
What is a stored procedure transformation?
How to implement security measures using repository manager?
What is aggregator transformation in informatica?
Can we create two repositories on same database instance in oracle?
Briefly explain the aggregator transformation?
What is a mapplet/worklet in informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is a node in Informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
