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...

please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.

Answer Posted / padmalatha0923

star schema: it can be defined as a fact table sorrounded dy dimension tables and all the dimension tables should be de-normalised
snow flake schema: it can be defined as fact tables sorrunded by dimension tables and those dimension tables atleast one dimension table should be normalised

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

924


Explain what task is 98% of the required work of a business analyst?

1016


Explain what is the difference between business requirement document and use case document.

964


How to create Index to the table in the universe designer and how it improves the Query performence

2502


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1789


What is the difference between slice and dice and cross tab report?

995


In banking domain how many Fact tables,Dimension table are present?

8743


Explain is there any default username & pwd for bo designer & supervisor?

948


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

942


Explain what are the steps to be taken to schedule the report?

1044


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

982


What is the profile and package?

2251


how to prepare the documentation in business objects and where to get the requirement?

2155


what will be the contents for a functional requirements specifications

2288


Explain about alerts in bos, under what situation we need to use alerts?

985