Need Help

[paulwalker]

Hi Community,

Please any one can explain brief Extended Interval Match??

Thanks in Advance..............

[Gysbert_Wassenaar]

Can you tell us what you don't understand after searching for and reading discussions about this subject? https://community.qlik.com/search.jspa?q=intervalmatch+extended

[paulwalker]

HI Gysbert,

I have read blogs.. but I am little confusion

Ans1:

Extended Interval Match is used when you have more keys like Primary and Foreign Key Relation (apart from just Startdate/Enddate) to be matched. So, it does not reduce the number of joins..

Ans2:

Some blogs written Extended Interval Match only for SCD (Slowly Changed Dimension)

Which one is Correct????

[Gysbert_Wassenaar]

The extended syntax for intervalmatch does not reduce the number of joins. Intervalmatch doesn't join tables. The JOIN keyword is used to join tables.

Intervalmatch can in some cases be used to deal with slowly changing dimensions. But there are other ways. And intervalmatch (with or without extended syntax) can be used for other problems too.

[paulwalker]

Thanks for Clarification...