QSM-00506: no fact-tables could be found



QSM-00506: no fact-tables could be found..

Answer / guest

Cause: The fact-filter is not specified, and there are no
fact-tables in the warehouse. A fact-table is a table having
foreign-key constraints to one or more of the
dimension-tables in the data warehouse.

Action: Check the fact-filter is correctly specified; check
that appropriate constraints exist; and the user has
privileges to access the tables

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19209: invalid or unsupported formatting argument

1 Answers  


DRG-11008: invalid create index partition parameter string

1 Answers  


SQL*Loader-00417: SQL string (on column string) not allowed in direct path.

1 Answers  


IMG-00580: specified format does not support output

1 Answers  


NZE-29152: SHA-1 self-test failure

1 Answers  






NID-00128: Cannot revert change of database, change not in progress

1 Answers  


RMAN-08535: channel string: looking for autobackup on day: string

1 Answers  


PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

1 Answers  


PCB-00240: Group item containing this host variable cannot be table

1 Answers  


ORA-26677: Streams downstream capture process string cannot proceed

1 Answers  


ORA-25014: cannot change the value of a PARENT reference variable

1 Answers  


NNL-00039: no RRs

1 Answers  


Categories