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

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

what is advantages of snowflake when it is used?

Question Posted / aug03

Answers were Sorted based on User's Feedback



what is advantages of snowflake when it is used? ..

Answer / sudhakar

the main disadvantage of snowflake schema is its normalised
format, so performance is poor and it is complex.

Is This Answer Correct ?    0 Yes 0 No

what is advantages of snowflake when it is used? ..

Answer / kishore

snowflake schema has normalized data i.e one dimension table
contains another dimension table like parent table and
child table
we can't get the data from child table directly i.e it
manitains secrecy

Is This Answer Correct ?    0 Yes 0 No

what is advantages of snowflake when it is used? ..

Answer / raja sekhar

this can be used when the project data having the more number of devisions along with sub devision in one particular part of department. and more number of duplicated data is used for the project developmen. eg. pharma projects....

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Data Stage Interview Questions

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

How do you design PX Routines ?

1 Answers  

what is use of SDR function?

0 Answers   CGI,

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  

What are the partition techniques available in your last project?

1 Answers  

what is the definitions for Datawarehose and Datamart?

4 Answers  

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,

What is difference between server jobs & parallel jobs?

0 Answers  

what is combinability and non combinability?

2 Answers  

root tree will find which is server job and which is parallel job?

0 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories