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

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

Tweet Share WhatsApp

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 PDF Read All 39 Oracle ETL Questions
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?