Master table and Transaction table

[arulsettu]

Hi

    i am new to this tables previous i know is fact table and dimensions table.

my question is to create a data model how to use these master and transaction table

please suggest something

thanks

[arulsettu]

Transaction table is fact table?

[tresesco]

Yes, in a broad sense. However, the term fact table is more appropriate when we talk about date modelling, whereas, transactional table is in raw database.

[arulsettu]

so can i load transaction table as fact table and master table as dimension table right?

[tresesco · Accepted solution]

You can. But simply loading them might not give you a perfect model, that might seek for some modifications to that simplicity(again that depends on your tables)

[jagan]

HI,

Fact Table is nothing but the transaction table like Sales, Orders tables etc it has the core fields and some ID fields which qualifies the transactions like Customer, Salesman, Branch, Region etc.

Where Master tables are those which has the details of Customers, Salesman, Branch etc.

The Fact table is surrounded by the Master/Dimension tables.

Hope this helps you.

Regards,

Jagan.

[arulsettu]

can you tell me what are the thing i have to consider

like a expale

[tresesco]

I suggest to search this forum for star schema creation technique/best data modeeling practices, you would get many like:

http://community.qlik.com/message/79351#79351

http://community.qlik.com/docs/DOC-4744

[arulsettu]

thanks you all for replying