What is incremintal loading?
What is batch processing?
What is crass reference table?
What is aggregate fact table?
Submitted by: AdministratorIncremental loading means loading the ongoing changes in the OLTP.<br><br>Aggregate table contains the [measure] values ,aggregated /grouped/summed up to some level of hirarchy.<br>
Batch Processing means executing more than one session in single run at the same time. we can execute these session in 2 ways : <br>linear: exececuting one after another<br>parralel: executing more than one session at at time
Submitted by: Administrator
Batch Processing means executing more than one session in single run at the same time. we can execute these session in 2 ways : <br>linear: exececuting one after another<br>parralel: executing more than one session at at time
Submitted by: Administrator
Read Online Data Warehousing Basics Job Interview Questions And Answers
Top Data Warehousing Basics Questions
| ☺ | Explain the definition of normalized and denormalized view and what are the differences between them? |
| ☺ | Explain degenerate dimension table? |
| ☺ | What is the main difference between schema in RDBMS and schemas in DataWarehouse? |
| ☺ | What are the Data Marts? |
| ☺ | Explain Differences between star and snowflake schemas? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
