Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i want one help below is my senario
i have main table with two ID columns
and one dimension table with one ID column . so want to link main table two id columns to dimension ID column
MainTable:
Sale_ID
Pro_ID
DImTable:
Sale_ID
Now Bussines told sale_id and Prod_id should link to Sale_Id in Dim table
how to do this?
Hi, It can be different options.
One can be duplicate data in main table, like:
Maintable:
LOAD *, Sale_ID as RelationField_ID From...;
Concatenate LOAD *, Pro_ID as RelationField_ID From...;
And dimTable should use RelationField_ID to link tables:
DimTable:
LOAD Sale_ID as RelationField_ID
...
Hi, It can be different options.
One can be duplicate data in main table, like:
Maintable:
LOAD *, Sale_ID as RelationField_ID From...;
Concatenate LOAD *, Pro_ID as RelationField_ID From...;
And dimTable should use RelationField_ID to link tables:
DimTable:
LOAD Sale_ID as RelationField_ID
...