SCD

[deepakqlikview_123]

Which type of SCd generally we can use in qlikview.

Type2 or type3

[rbecher]

I would suggest SCD type 2 but you can code what you want..

[deepakqlikview_123]

Hi to handle SCD in UI without using interval match function

Can you please give me some example.

[rbecher]

You should handle SCD in the load script and create a classical star schema data model. Create surrogate keys for each historical dimension record to link the right facts.

[deepakqlikview_123]

Can you please share with me example.

thanks

[hic]

See Slowly Changing Dimensions. Examples can be found under IntervalMatch and Slowly Changing Dimensions

HIC

[rbecher]

It depends on your use case. I suggest to read Ralph Kimball's "The Data Warehouse Toolkit". It contains a lot of examples related to common use cases.