Ambiguous while data modeling.

[#1]

Hi All,

I have loaded data from Oracle DB of (BI data)

Loaded data is SALES, PRODUCTS, CUSTOMER, COUNTRY, PROMOTIONS,TIMES,COSTS.

Applied Inner Join for (Product and cost) & (Country and Time).

I have done this to avoid Synthetic keys but now all table are directly or indirectly attached to Product table.

[engishfaque]

Dear Narsing,

Remove circular loop from your data model.

Remove or Rename your CHANNEL_ID as the circular loop can be removed.

Kind regards,

Ishfaque Ahmed

[ramasaisaksoft]

Hi Narsing,

What you want exactly? output

As per my understanding ,try to resolve circular loop for that

1) u can alias the field names individually with in table

2) Remove unnecessary columns from script

3) try to use Qualify & Un-qualify  fields depends on ur requirement

else please create a temp excel file with your data then we will send example qvw file with your output

[Peter_Cammaert]

IMHO you should connect dimension tables as much as possible to your facts table (SALES). A quick way to do this is to detach PROD from COUNTRY (?) and attach PROD to SALES by way of PROD ID. If you have time- & channel-based records in your products table, create a composite key from PROD ID, CHANNEL ID and TIME to connect PROD to SALES.

But to be able to create a correct data model, we need to know what these tables and fields really contain. I hope you do know what's in them. Can you shed some light on these tables?

Peter