Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
RebeccaD Oct 12, 2015 9:44 AM
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!
This poster needs help right now. Drop what you are working on and help him – his deadline is your deadline!
This poster includes his entire QVW script in his question. All thirty-four pages of it. The error is in there somewhere!
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…
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
Well, that wasn't very helpful. Why not point out something like this instead: QlikCommunity Tip: How to get answers to your post?
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