topic Re: Snow to star in QlikView

Snow to star

hari8088 — Sun, 05 Jul 2015 16:06:18 GMT

Hi All,

When i am change my data model from snow to star schema.

Is there any possible to loss data or fields or tables?

Re: Snow to star

Anonymous — Sun, 05 Jul 2015 16:47:19 GMT

Hi,

pls can you explain more?

It is a generic question and is better if you say more things.

How do you changhe from snow to star schema?

With mapping load?

With Join?

Best regards.

Re: Snow to star

hari8088 — Sun, 05 Jul 2015 16:53:03 GMT

YES .

what i am saying here is my current datamodel is having snowflake schema ,

now i want make it to star schema

when i am making it into star schema is there any possibilities of loosing the data ?

as well as any fields ?

if i am going to loss some data due to this converting snowflake to star schema then whats the reason ?

Thanks in advance

Re: Snow to star

sunny_talwar — Sun, 05 Jul 2015 16:55:50 GMT

Unless you leave a field out by mistake, I don't see how your field can be lost. And with regards to your data itself, when joining things together don't use Left, Right or Inner joins and I don't think any data should be lost.

HTH

Best,

Sunny

Re: Snow to star

maxgro — Sun, 05 Jul 2015 17:08:41 GMT

no, they only are different ways of designing the data model

Re: Snow to star

Anonymous — Sun, 05 Jul 2015 17:13:12 GMT

No, you dont loss data or field if you dont do a mistake, I think.

I do many times this, a very important thing is that you do this step-by-step, so you do for the first table and then you control that is all ok and so you continue with other table and control.

You can avoid many mistakes.

Best regards.

Re: Snow to star

robert_mika — Sun, 05 Jul 2015 21:44:35 GMT

If you in doubt attached your diagram from table Viewer.