Explain what is full load & incremental or refresh load?
- 1 Answers
- 1074 Views
- I also Faced
- E-Mail Answers
Answer / Shadab Ali
Full Load (or Initial Load) refers to the first loading of data into a Data Warehouse. Incremental or Refresh Load involves updating existing data in a Data Warehouse based on new or changed records from the source systems, typically performed at regular intervals.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the key columns in Fact and dimension tables?
Explain how to generate iqd file from framework manager?
What are the primary ways to store data in OLAP?
Explain what are the various reporting tools in the market?
State any 5 of Cods guidelines of an OLAP system, brief description each?
Explain what are the different types of join operations?
How many repositories can we create in Informatica?
Explain the main differences between star and snowflake schema?
Explain why dimenstion tables are denormalized in nature?
What is the difference between constraind base load ordering and target load plan?
Can you state some of the innovations throughout history?
I have two universes created by two difference database can we join them in designer & report level? How
Teradata 
