Difference

manoranjan_d — Wed, 07 Oct 2015 21:42:48 GMT

wht is the difference between concatenate and union

wht is the difference between Fact and dimension

wht is the difference between concatenate and join

wht is the difference between star and snowflake schema

Re: Difference

MarcoWedel — Wed, 07 Oct 2015 22:28:16 GMT

Hi,

there should be lots of information available to those topics using the community search function:

https://community.qlik.com/search.jspa

hope this helps

regards

Marco

Re: Difference

Thu, 08 Oct 2015 03:15:23 GMT

Refer links below

wht is the difference between concatenate and union : https://community.qlik.com/thread/103418

wht is the difference between Fact and dimension : https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/25/dimensions-and-measures

wht is the difference between concatenate and join : https://community.qlik.com/thread/39177

wht is the difference between star and snowflake schema : https://community.qlik.com/thread/117673

Re: Difference

qlikviewwizard — Thu, 08 Oct 2015 04:01:35 GMT

Re: Difference

ramasaisaksoft — Thu, 08 Oct 2015 05:00:59 GMT

Hi Manoranjan,

1) wht is the difference between concatenate and union?

A) Concat is an aggregation function.

SQL unions require that the same fields, with the same data types exist in each SELECT in the same order.

QV concatenates do not require any of these, but 'missing' fields will get null values.

2)wht is the difference between Fact and dimension?

Fact tables are having value fields like currency,Product No..etcand these tables are having lot of fields

Here data is modified very frequently (Ex:- Share Market data,Bank data)

Dim Tables are having very less data and these tables are explaining perticularly about only one thing(ex:-bank branches in all cities,type of accounts maintain in a bank..etc)

Here data is not modified frequently.

3)wht is the difference between concatenate and join?

For joining two tables one filed should be comman in between two tables.

concatenation: combining the two tables if no common fields

Concatenating fact tables with some different fields is acceptable for creating sophisticated Data scheme,

it is not out of best practice, just depends on complexity of your ap

Two different concatenation is there Auto Concatenation and Force Concatenation

Auto Concatenation:

When Qlikview sees the two different tables with same number of fields and same field names. It will concatenated in to single table by itself.

Forced Concatenation:

Using Concatenate keyword before the Load statement. For the non-common fields between two tables will have the NULL value in other table rows.

4)wht is the difference between star and snowflake schema?

If your database is normalized then snowflake is used, but there are performance issues using this schema, because at the number of joins are increased. That is why in Qlikview Star Schema is preferred, snowflake is converted to star by joining the Fact and Sub Fact tables. For less data you can't the performance issues, but when the data is huge you can notice the performace issues.

SnowFlake : Region (Table) -> Country(Table) -> City (Table) (All are separate fact tables)

Star : One table has all the fields (by joining all the tables)

Hope this helps you.

Re: Difference

manoranjan_d — Thu, 08 Oct 2015 13:06:39 GMT

thanks to all

topic Re: Difference in QlikView

Difference

Re: Difference

Re: Difference

Re: Difference

Re: Difference

Re: Difference