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

star and snowflake schema?

Answer Posted / rr

Star schema has denormalised dimension tables connected to
a single fact table.
Snow flake schema has normalised dimension tables.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2245


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2352


What are the main issues while working with flat files as source and as targets ?

1214


Explain what are the different versions of informatica?

1143


Explain scd type 3 through mapping.

1051


How to generate sequence numbers?

1129


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7175


Explain what are the different types of transformation available in informatica.

1244


What are the features of complex mapping?

1203


How many types of sessions are there in informatica.please explain them?

1210


How is union transformation utilized?

1058


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7493


What is informatica etl tool?

1055


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1138


What are the measure objects?

1252