FACT & dimension

[#1]

i have a fact table and dimension table .

how to combine it?

[MK_QSL]

There should be some common field between them...

Consider that you have fact table ... Sales having below fields

CustomerID

SalesDate

SalesQty

SalesAmout etc etc

and a Dimension Table Customer with below fields..

ID

Name

Country etc etc.

rename the Customer Table's ID field as CustomerID, which will now create an association between Sales and Customer Table..

[#3]

Hi, manish

its good but i want to show the two tables into a single table in datamodel

its join or concateneate

[#4]

Hi, manish

its good but i want to show the two tables into a single table in datamodel

its join or concateneate

[MK_QSL]

For my example

Sales:

Load

     CustomerID,    

     SalesDate,

     SalesQty,

     SalesAmout

From TableName....

Left Join (Sales)

Load

     ID     as CustomerID,

     Name,

     Country

From TableName ....

[#6]

if we have no common fields then?

[MK_QSL]

Not possible to link them... ....

Let us know your tables and their fields you are talking about..

[#8]

It all depends on How the tables are related and what is your requirement on the UI to represnt the data

[#9]

It all depends on How the tables are related and what is your requirement on the UI to represnt the data

[#10]

You can do either of one depends on the Tables data attributes.