need suggestion

[soniasweety]

Hi all,

@sunny_talwar   @rubenmarin1 

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?

[rubenmarin1 · Accepted solution]

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

...

[soniasweety]

thanks i will try and let you know,