What is a lookup table?
Submitted by: AdministratorA lookUp table is the one which is used when updating a warehouse. When the lookup is placed on the target table (fact table / warehouse) based upon the primary key of the target, it just updates the table by allowing only new records or updated records based on the lookup condition.
Submitted by: Administrator
Submitted by: Administrator
Read Online General Datawarehousing Job Interview Questions And Answers
Top General Datawarehousing Questions
| ☺ | What is SCD1 , SCD2 , SCD3? |
| ☺ | What is ODS? |
| ☺ | Explain piconet? |
| ☺ | Explain the Difference between OLTP and OLAP? |
| ☺ | Explain What are the Different methods of loading Dimension tables? |
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. |
