Hi, I am trying to create an Aggregate Join Index with below sql..
This is kind of aggrigate table coming from joining 1 fact and 6 dimention table.. so I have not added any primary key. is this incorrect?
After GROUP BY there is few CASE statements. Is it possible to include in the SELECT clause and give a try?