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-31506: duplicate subscription name string

1 Answers  


ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3970712838_6793 by 128 in tablespace SYSAUX? What is the solution for this issue?

2 Answers   Oracle,


TNS-00078: * log_on - ask process_name to turn logging on

1 Answers  


ORA-27014: skgfqpini: translation error while expanding SS_UDMPDIR

1 Answers  


ORA-13387: sdo_batch_size for array inserts should be in the range [number,number]

1 Answers  






PCC-01002: Invalid character "character" in indicator area at line number in file string

1 Answers  


QSM-02071: internal error: undefined PCT failure code

1 Answers  


ORA-01510: error in deleting log files

1 Answers  


SQL*Loader-00105: Invalid data file name on command line

1 Answers  


ORA-13203: failed to read USER_SDO_GEOM_METADATA view

1 Answers  


ORA-27451: %s cannot be NULL

1 Answers  


ORA-29290: invalid offset specified for seek

1 Answers  


Categories