topic Re: Data Model in QlikView

Data Model

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

What is this Data Model Name?

Re: Data Model

Chanty4u — Tue, 24 May 2016 10:23:00 GMT

start Schema

Re: Data Model

qlikview979 — Tue, 24 May 2016 10:24:48 GMT

Hi Chanty,

Here No Fact table How Can identify that? I think This is a relation Between 4 tables.

Regards

Mahesh.

Re: Data Model

ajsjoshua — Tue, 24 May 2016 10:29:46 GMT

Hi,

Try this Joining 4 tables that share 3 fields | Qlik Community

Re: Data Model

Kushal_Chawda — Tue, 24 May 2016 10:33:24 GMT

You can call it as linked tables which are linked on Same key field

Re: Data Model

Anil_Babu_Samineni — Tue, 24 May 2016 10:43:12 GMT

Associative Normalized Table. Because, There is no Fact Table. Whenever created one Associative with out Fact table then we normally call ANT.

Re: Data Model

ramasaisaksoft — Tue, 24 May 2016 10:58:22 GMT

Hi Mahesh,

Tables are joined/Associated with the help of Product Key.

There is no Schema here as per my Knowledge.

Re: Data Model

Clever_Anjos — Tue, 24 May 2016 11:07:34 GMT

Im my humble opinion, you don´t have a standard Star or SnowFlake schema.

I can see 4 tables, probably facts (they have dates, they have invoice numbers, etc) that could be concatenated into one table and become a Flat Table

Re: Data Model

qlikview979 — Tue, 24 May 2016 11:11:52 GMT

Hi Kushal,

I think this is relationship between four tables with one common field.

Here no Fact table table How can i call link table.Can you Explain me

Regards,

Mahesh.

Re: Data Model

qlikview979 — Tue, 24 May 2016 11:15:35 GMT

Hi,

I got it, but here I think This Data model is not Link table. is it correct?

regards,

Mahesh.

Re: Data Model

Clever_Anjos — Tue, 24 May 2016 11:19:57 GMT

No, it´s not a Link Table

Re: Data Model

qlikview979 — Tue, 24 May 2016 11:22:24 GMT

Hi Clever Anjos,

Thanks for your Quickly Responding

Regards,

Mahesh

Re: Data Model

Kushal_Chawda — Tue, 24 May 2016 11:34:37 GMT

Don't get confused between "link table" and "linked table". Link table is something you create using multiple fact table. Linked tables are the table which are simply linked on particular field.

Re: Data Model

qlikview979 — Tue, 24 May 2016 11:40:38 GMT

Hi Kushal,

Superb, Its A very good answer

Regards,

Mahesh.

Re: Data Model

sujeetsingh — Tue, 24 May 2016 11:48:02 GMT

Do not try to name it just explore its pros and cons