Solved: Data Model - Qlik Community

qlikview979 · ‎2016-05-24

Hi Experts,

What is this Data Model Name?

Kushal_Chawda · ‎2016-05-24

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.

View solution in original post

Chanty4u · ‎2016-05-24

start Schema

qlikview979 · ‎2016-05-24

Hi Chanty,

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

Regards

Mahesh.

ajsjoshua · ‎2016-05-24

Hi,

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

Kushal_Chawda · ‎2016-05-24

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

Anil_Babu_Samineni · ‎2016-05-24

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

ramasaisaksoft · ‎2016-05-24

Hi Mahesh,

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

There is no Schema here as per my Knowledge.

Clever_Anjos · ‎2016-05-24

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

qlikview979 · ‎2016-05-24

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.

qlikview979 · ‎2016-05-24

Hi,

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

regards,

Mahesh.

Data Model

Related Topics