What is the difference between narmal load and bulk load?
Answer / soumith avunoori
The main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data cannot be recovered.
| Is This Answer Correct ? | 0 Yes | 0 No |
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
What is aggregate awareness?
what is table partitioning? How it is useful to warehouse database?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Why is chameleon method used in data warehouse?
What is execution plan?
How can you import tables from a database?
What are Non-additive facts?
Explain what are the advantages of query studio compared to report studio?
What is hash partition?
What are cluster analysis in data warehousing?
What is Operational Data Store?