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
- 18977 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rayudu
hi,
Flat file doesn't contain any indexes or keys so it will
directly load into it. whereas in a table it will first
check for indexes and keys while loading into table so it is
slow when compared to flat file loading.
Regards,
rayudu.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are session parameters ? How do you set them?
What is fact table? Explain the different kinds of facts.
Can anyone tell me the new features in Informatica 9 Version?
What are the main features of Oracle 8i with context to datawarehouse?
What is the sequence generator transformation in informatica?
What is persistent lookup cache?
What is the way to execute pl/sql script using informatica mapping?
Could you explain what is enterprise data warehouse?
What is the command used to run a batch?
How an expression transformation differs from aggregator transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
where to store informatica rejected data?
