Oracle Extract transform load (ETL) Question:
Download Questions PDF

What is fact less fact table? where you have used it in your project?

Oracle ETL Interview Question
Oracle ETL Interview Question

Answer:

Fact less table means only the key available in the Fact there is no measures available.

factless fact table means that contains only foreign keys with out any measures example:attendance report of employees in a particular company contains no measures only

Download Oracle ETL Interview Questions And Answers PDF

Previous QuestionNext Question
What are snapshots? What are materialized views & where do we use them? What is a materialized view?Can we look-up a table from source qualifier transformation. ie. unconnected lookup?