Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact table and factless table?
- 1 Answers
- 7243 Views
- I also Faced
- E-Mail Answers
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 |
Explain the difference between informat and format with an example.
HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;
Which command is used to save logs in the external file?
How do you put a giraffe into the refrigerator?
What are _numeric_ and _character_ and what do they do?
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
In SAS explain which statement does not perform automatic conversions in comparisons?
What are the data types in sas?
how to know the attributes of first five datasets in a library
Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.
what are the types of interactive display types? : Sas-bi
Teradata 
