Suppose I have mainly two transacion table.Then how to make Data Model for it.How to apply logic for it.Wheather I have to concatenate both tables and make flag for Field or any other logic ??
Please can any one help me I am little bit confused in it....
If both table having same or close structure then its best to concatenate both tables. if you need to differentiate transaction from the table then you add a new field as a flag of the table
FactTable:
Load
ProdID,
Sales,
SaleDate,
'Region1' as TransactionSource
From RegionSales1.QVD
Concatenate
Load
ProdID,
Sales,
SaleDate,
'Region2' as TransactionSource
From RegionSales2.QVD
Then you may use Set Analysis in your application to sum only sales from Region1 as
