topic Re: Master table and Transaction table in QlikView

Master table and Transaction table

arulsettu — Fri, 06 Feb 2015 04:19:42 GMT

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

Re: Master table and Transaction table

arulsettu — Fri, 06 Feb 2015 04:35:18 GMT

Transaction table is fact table?

Re: Master table and Transaction table

tresB — Fri, 06 Feb 2015 04:59:11 GMT

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.

Re: Master table and Transaction table

arulsettu — Fri, 06 Feb 2015 05:23:18 GMT

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

Re: Master table and Transaction table

tresB — Fri, 06 Feb 2015 05:28:15 GMT

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)

Re: Master table and Transaction table

jagan — Fri, 06 Feb 2015 05:30:01 GMT

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.

Re: Master table and Transaction table

arulsettu — Fri, 06 Feb 2015 05:34:13 GMT

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

like a expale

Re: Master table and Transaction table

tresB — Fri, 06 Feb 2015 05:44:01 GMT

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

Re: Master table and Transaction table

arulsettu — Fri, 06 Feb 2015 05:45:50 GMT

thanks you all for replying