tried to create link table. is it correct then how to validate it?

[sharmaKavita]

WebSales:
LOAD
DateKey,
ProductKey,
// DateKey & ProductKey as ltkey,

CustomerKey,
PromotionKey,
CurrencyKey,
DateKey & ProductKey & CurrencyKey as ltkey,
SaleTypeKey,
OrderDate,
DueDate,
ShipDate,
SalesOrderNumber,
SalesOrderLineNumber,
RevisionNumber,
OrderQuantity,
UnitPrice,
UnitPriceDiscountPct,
ProductStandardCost,
TotalProductCost,
SalesAmount,
TaxAmt,
Freight,
ExtendedAmount
FROM [lib://source/WebSales.qvd]
(qvd);

ProductInventory:
LOAD
ProductKey,
DateKey,
DateKey & ProductKey as ltkey,
UnitCost,
StockOut,
StockOutDate,
StockIn,
StockInDate,
StockOnHand,
StockBackOrderQty,
StockBackOrderDate,
MinStockLevel,
MaxStockLevel,
StockTakeFlag
FROM [lib://source/ProductInventory.qvd]
(qvd);

ForeignexchangeRate:
LOAD
CurrencyKey,
DateKey,
DateKey & CurrencyKey as ltkey,
"Date" as Closedate,
Country,
XRate
FROM [lib://source/ForeignExchangeRates.qvd]
(qvd);

Currency:
LOAD
CurrencyKey,
CurrencyAlternateKey,
CurrencyName
FROM [lib://source/currency.qvd]
(qvd);

[Henry_Laser]

Hi,

What script did you use to create your link table? Will this be possible for you to share? Also, You will need at least one dimension in all tables that you want to link, to be the same in naming for this to work correct.

[Lokesh_5045]

From the script that you shared, I guess data gets doubled or may not give correct values. Though the name of the key in all tables is same, it is created with different combination of fields.