Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am going to get 1.5 billion rows with three fields (i.e.Name and Rule and Indicator).
Each Name can have 'n' number of rules.
My question is, if I show each rule as a Column name, will that decrease the number of rows?
If Yes, Is it better to do in the script or directly use pivot table and show in the front end. Which will have better performance?
Issue I think if we create each distinct Rule as a column name:
As the Rules can be 'n' number, we need to create them as a dimension and use calculated dimension.
Which will have better performance?
Thanks in advance!
Thanks,
Varun Reddy. K