General Datawarehousing Question:
Download Job Interview Questions and Answers PDF
Explain What are the Different methods of loading Dimension tables?
Answer:
Conventional Load:
Before loading the data, all the Table constraints will be checked against the data.
Direct load:(Faster Loading)
All the Constraints will be disabled. Data will be loaded directly.Later the data will be checked against the table constraints and the bad data won't be indexed.
Before loading the data, all the Table constraints will be checked against the data.
Direct load:(Faster Loading)
All the Constraints will be disabled. Data will be loaded directly.Later the data will be checked against the table constraints and the bad data won't be indexed.
Download General Datawarehousing Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain piconet? | What is ODS? |