Finding this bit tricky.. Can someone pl help on this.
I need to capture the missing ProductID and the customerIDs while loading the data into SalesFact. Need to load the data only when the CustID and ProductID are there in the customer & Product tables. Also, I need to reject those custID, ProductID which are not there in the customer & Product tables
to an error table ... This is just an example, in my case, I need to lookup almost 6 tables (Product, customer etc.,) and perform rejection
Customer:
Load * Inline [
CustID,Custname,Address
10,'Subash',Indra Nagar
11,'Ashok',Chromepet ];
SalesFact:
Load * Inline [
InvID,ProductID,CustomerID,SalesrepID,ShipperID,Sales,Margin
1,10,10,AA1,SH1,25800,40
2,11,10,AA1,SH1,15800,40
3,16,10,AA1,SH2,25800,40
4,15,12,AA1,SH2,25800,40 ];
Product:
Load * Inline
[
ProductID,ProdName,Price
10,P1,100
12,P2,150
];
