Answer Posted / 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 |
Post New Answer View All Answers
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
name some data transformation used in sas di? : Sas-di
What do the SAS log messages "numeric values have been converted to character" mean?
is data integration and etl programming is same? : Sas-di
What are the scrubbing procedures in sas?
Differentiate between ceil and floor functions.
What is the general format of function in sas? : sas-grid-administration
what other sas products have you used and consider yourself proficient in using? : Sas programming
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
explain the proc in sas? : Sas-administrator
How to convert a numeric variable to a character variable?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
How can you limit the variables written to output dataset in data step?
In ARRAY processing, what does the DIM function do?
Describe a time when you were really stuck on a problem and how you solved it?