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 |
What is data mart in data warehouse?
Describe a data warehouse.
How can you implement many relations in star schema model?
what is data validation strategies for data mart validation after loading process
Explain difference between view and materialized view?
Explain what is a view as it relates to system modeling?
What is incremintal loading?
WHAT IS FACT LESS FACT TABLE?
Explain some of modeling tools available in the market?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
How to performance tune reports?
What is fact less fact table? Where you have used it in your project?