Archives of the TeradataForum
Message Posted: Thu, 10 Aug 2000 @ 13:09:29 GMT
| Subj: || || Re: SOS! Teradata and Business Objects |
| From: || || Dave Sedgwick |
Thanks for that Dave, the answer is similar to what you've described. The reason it was spooling was actually an object in the universe
that was using the original table name not the aliased name. It did not reveal itself in the universe as clicking on the table that has
been aliased and selecting 'view associated objects' revealed nothing - an interesting feature. If a designer does create an alias table
and performs this check they would assume all objects have been correctly changed to use the alias name. Obviously as the aliased table is
not joined to anything it was doing a 1=1 product join between two sizeable tables.
Right, that's one cracked, next one is figuring out the union part of the report query...