How to avoid Synthetic keys (Fact tables)? Creating Link/Key tables - QlikView Tutorial Session 20
In this session you will learn about Concatenating Fact tables to avoid Synthetic keys and Creating Link/Key tables
Concatenating Fact Tables To Avoid synthetic Keys
-----------------------------------------------------------------------
Store:
LOAD * INLINE [
StoreID, StoreName
1, Store A
2, Store B
];
Calender:
LOAD MonthID as DateID, Month INLINE [
MonthID, Month
1, Jan
2, Feb
];
Product:
LOAD * INLINE [
ProductID, Product
1, Product A
2, Product B
];
Sales:
LOAD * INLINE [
DateID, StoreID, ProductID, SaleQty, SaleValue
1, 1, 1, 2, 23
1, 1, 2, 4, 24
2, 1, 1, 4, 33
2, 1, 2, 3, 28
1, 2, 1, 2, 21
1, 2, 2, 4, 30
2, 2, 1, 3, 25
];
Waste:
LOAD * INLINE [
DateID, StoreID, ProductID, WasteQty, WasteValue
1, 1, 1, 1, 10
2, 1, 2, 1, 9
1, 2, 2, 2, 17
2, 2, 2, 1, 8
];
Creating Link Table/Key Table
-----------------------------
Store:
LOAD * INLINE [
StoreID, StoreName
1, Store A
2, Store B
];
Calender:
LOAD MonthID as DateID,Month INLINE [
MonthID, Month
1, Jan
2, Feb
];
Product:
LOAD * INLINE [
ProductID, Product
1, Product A
2, Product B
];
Sales:
LOAD * INLINE [
DateID, StoreID, ProductID, SaleQty, SaleValue
1, 1, 1, 2, 23
1, 1, 2, 4, 24
2, 1, 1, 4, 33
2, 1, 2, 3, 28
1, 2, 1, 2, 21
1, 2, 2, 4, 30
2, 2, 1, 3, 25
];
Budget:
LOAD * INLINE [
StoreID, ProductID, BudgetQty, BudgetValue
1, 1, 5, 50
1, 2, 6, 47
2, 1, 5, 41
2, 2, 4, 27
];
Create a Unique key field in both Tables
Create a new table by using Common Fields
Drop Common fields in both Tables except Unique Key Field
On this page of the site you can watch the video online How to avoid Synthetic keys (Fact tables)? Creating Link/Key tables - QlikView Tutorial Session 20 with a duration of hours minute second in good quality, which was uploaded by the user Trending Courses 28 December 2018, share the link with friends and acquaintances, this video has already been watched 2,670 times on youtube and it was liked by 27 viewers. Enjoy your viewing!
