Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to build a fact table for below scenario. Please guide me.
Now the target to merge the 2 QVDs (structure of both QVDs are same) into one Fact table. What would be the correct approach for this, so that in report I can easily show the distinguished data?
Regards!
concatenate the 2 tables adding a field to distinguish them
then use set analysis to filter the different tables depending on tab
maybe this can help you (also look for generic key in community)