3.What is fact less fact ?

Answer Posted / pratap gangula

There can be only two aggregate functions in a fact less fact table....count and distinct count on the foreign keys.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the data types present in bo n wht happens if we implement view in the designer n report?

536


What is the difference between a primary and secondary actor in use case modeling?

578


What are the mapping paramaters and maping variables?

566


What is the difference between constraind base load ordering and target load plan?

643


What is an er diagram?

634






Explain the difference between oltp and olap?

681


What are modeling tools available in the market?

557


Explain er diagram?

547


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1557


What is many-to-many dimensional model in datawarehousing ?

505


What is batch processing?

580


What are the design methods of data warehousing?

511


Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

501


What is ods (operation data source)?

551


"A dimension table is wide but the fact table is deep," explain the statement in your own words.

817