Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

-----------Types of Fact Tables?

Answer Posted / abd hfz

There are two types of Fact Tables namely :

1) Cummulative Fact Table : Facts collected over a period
of time are called CFT. This contains mainly Additive facts.

2) Snapshot Fact Table: Facts collected at the particular
time are called SFT. This are mainly Semi/Non Additive facts.

Also,
Fact less fact table : which has only FK and does not
contain any measures. eg: Visitors to the office

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how you migrate reports to cognos 8 from previous versions?

1048


After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

2035


What are the ways to import data into catalog?

1092


what is the role of cognos comsultant?what actually it means?pls reply

2326


Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

2129


9. What was the most complex type of report you dealt with?

2225


if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1924


----------------Describe DWH Architecture?

2074


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2450


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2325


what is the procedure for scheduling conditional rendering?

2534


2. What functional area you worked on.

2363


How create measures and dimensions?

1086


What is the deployment requirements used in cognos?

1662


explain how to create powerplay reports?

1022