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 are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain what does level of granularity of a fact table signify?
What are the possible data marts in retail sales?
How do you define data block size?
What is Time Series algorithm in data mining?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
How many types of facts and what are they?
How to test report in reportnet?
Explain what is the advantages data mining over traditional approaches?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Describe the differences between a data warehouse and data mart.
What is data warehosuing hierarchy?