There can be only two aggregate functions in a fact less fact table....coun

3.What is fact less fact ?

Question Posted / pratap gangula

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

Please Help Members By Posting Answers For Below Questions

What is a fact, dimension, measure?

1209

Compare cold fusion with other programming languages?

1008

can anybody mail me the FAQS for hyperion essbase amd planning

5646

Explain what is a three tier data warehouse?

975

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1184

How can we do data cleaning?

1061

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953

What is execution plan?

1205

How can we schedule the graph in unix?

1000

Whether dimension table can have numeric value?

1151

How do you setup Lo-cockpit?

3166

What is Sequence clustering algorithm?

2029

What do you mean by static and local variable?

963

What is the data type of the surrogate key?

1006

What are vaious etl tools in the market?

1004