Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

can u please built example script to built star schema with following Date please

H:

LOAD CategoryID,

CategoryName,

Description;

SQL SELECT * FROM Categories;

A:

LOAD

Address,

City,

CompanyName,

ContactName,

Country,

CustomerID,

DivisionID,

Fax,

Phone,

PostalCode,

StateProvince;

SQL SELECT * FROM Customers;

B:

LOAD

DivisionID,

DivisionName;

SQL SELECT * FROM Divisions;


C:

LOAD

Discount,

LineNo,

OrderID,

ProductID,

Quantity,

UnitPrice;

SQL SELECT * FROM `Order Details`;


😧

LOAD

CustomerID,

EmployeeID,

Freight,

OrderDate,

OrderID,

ShipperID;

SQL SELECT * FROM Orders;


E:

LOAD

CategoryID,

ProductID,

ProductName,

QuantityPerUnit,

SupplierID,

UnitCost,

UnitPrice,

UnitsInStock,

UnitsOnOrder;

SQL SELECT * FROM Products;


F:

LOAD

CustomerID,

EmployeeID,

LineNo,

OrderID,

ProductID,

ShipmentDate,

ShipperID;

SQL SELECT * FROM Shipments;


G:

LOAD

CompanyName,

ShipperID;

SQL SELECT * FROM Shippers;

2 Replies
Gysbert_Wassenaar

Are you just trying to get somebody else to do your homework or do you want to know how to create a star schema? If the latter then can you tell us what you're having trouble with?


talk is cheap, supply exceeds demand
marcus_sommer

This will help you: Get started with developing qlik datamodels

- Marcus