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 / tamilarasan m

Star fact table join with all the dimension tables.All the
dimension tables are denormalized.ain Snowflake dim table
join with another dimension.All the dimension r normalized

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In informatics server which files are created during the session rums?

1107


What is mapping debugger?

991


How do you load unique records into one target table and duplicate records into a different target table?

1205


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2040


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1071


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1980


I have a flat file, want to reverse the contents of the flat file

1109


Explain sql transformation in script mode examples in informatica

1109


list out all the transformations which use cache?

1167


What is parallel processing in informatica?

1687


Enlist the various types of transformations.

1021


What is meant by pre and post session shell command?

1139


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1998


What is a dimensional model?

963


How to create or import flat file definition in to the warehouse designer?

1059