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

in which situations do u go for starflake schema ?

Answer Posted / padmavathi

When we bother about query performance we will go for
starschema modelling because in this modelling data
redundancy will be there while writing queries to retrive
data need not use more join conditions.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the main features of Oracle 8i with context to datawarehouse?

2156


What are the performance considerations when working with aggregator transformation?

1197


What do you mean by channel change?

1101


How can a transformation be made reusable?

1220


explain abt ur project architecture?

2229


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1136


How many ways are there to create ports?

1397


What is meant by query override?

1112


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1790


what is the difference between informatica6.1 and infomatica7.1

2356


which one is better performance wise joiner or look up

1147


What are the modules in Power Center

1716


In warehouses how many schemas are there?

1126


What is sq transformation?

1223


Which files are created during the session rums by informatics server?

1229