I'd face a "STRANGE" problem.
I'm using SQL2008 connect to Oracle Data Source (OracleOldDB.1)
When I process a snow-flake dimension .
There is a ORA-00942 problem.
But if I past the SQL Statement to a Oracle Tool .
It worked without any problem.
Does any body ever face this "STRANGE" problem ?
And I'd try to remove this table from data-source-view and re-join it .
Still same problem !!
View Complete Post