topic Re: SCD Logic?? in QlikView

SCD Logic??

Tue, 13 Oct 2015 15:32:17 GMT

Hi Community,

Can you help how to implement SCD (slowly changing dimension) ?

I have downloaded in Community, but i am confusing with that, i.e very lengthy..

Please anyone give simple example.....

Thanks in Advance...

Re: Need Help

Qrishna — Tue, 13 Oct 2015 15:39:19 GMT

The 4 Qlik Community Types We All Love to Hate

RebeccaD Oct 12, 2015 9:44 AM

1. The Vague But Desperate Poster

This poster usually includes a desperate plea for help in the title but then no information whatsoever in the body of the post. We can tell you need help, but with what? Help us help you!

2. The Really Important Guy

This poster needs help right now. Drop what you are working on and help him – his deadline is your deadline!

3. The TMI Poster

This poster includes his entire QVW script in his question. All thirty-four pages of it. The error is in there somewhere!

4. The Boss

This poster lists a set of requirements for the application he needs you to build. Oh, and he needs that by tomorrow afternoon. So if you could come in on Saturday…

Re: SCD Logic??

Gysbert_Wassenaar — Tue, 13 Oct 2015 15:51:14 GMT

Have you read some of the discussions about this subject yet? You can find a lot of those with this search: https://community.qlik.com/search.jspa?q=scd

This blog post is worth a read: Slowly Changing Dimensions

Re: SCD Logic??

Gysbert_Wassenaar — Tue, 13 Oct 2015 15:54:08 GMT

Well, that wasn't very helpful. Why not point out something like this instead: QlikCommunity Tip: How to get answers to your post?

Re: SCD Logic??

Nagaraju_KCS — Tue, 13 Oct 2015 16:17:18 GMT

HI,

Read hic posts..

https://community.qlik.com/docs/DOC-4310

It might be helpful...

Re: SCD Logic??

SreeniJD — Tue, 13 Oct 2015 16:22:37 GMT

Raju,

If you understand the logic of SCDs then you can easily implement SCDs in QV on your own...

In general the requirement would be more of implementing Type 2 SCDs... ie preserving history...

So.. How to preserve the history... as per Kimbal's DW Model there are essentially three types..

1) Versioning

2) Timestamp

3) Flags

Its your choice, how you would like to implement these options in QV...

HTH

Sreeni