what is fact table and factless table?
Answer / kishorebabu
Fact Table
The centralized table in a star schema is called as FACT
table. A fact table typically has two types of columns:
those that contain facts and those that are foreign keys to
dimension tables. The primary key of a fact table is
usually a composite key that is made up of all of its
foreign keys.
In the real world, it is possible to have a fact table that
contains no measures or facts. These tables are called as
Factless Fact tables.
| Is This Answer Correct ? | 2 Yes | 0 No |
One way of creating a new variable in Macros is by % Let....What is the other way..?
what is cummaltive frequency,and varience in proc unviarte
Tell e how how dealt with..
What versions of SAS have you used (on which platforms)?
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
Name statements that function at both compile and execution time?
Mention few ways with which a “table lookup’ is done in sas programming.
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
what is the difference btw proc means and proc univariate?
Which function is used to count the number of intervals between two sas dates?
How can you create a macro variable with in data step? : sas-macro
What are the main differences between sas versions 8.2, 9.0, 9.1?