Answer / rr

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

Answer / sathish

Star Schema

Star Schema is the type of modeling where we follow the
complete de-normalization process.A star schema contains
multiple dimensions which share the same fact table.

Say per example in the sales analysis star schema, the
actual sales goes into fact and the customer, product, date,
sales force information goes as dimensions.

Snowflake Schema

In order to strike a balance between 3rd normal form data
model and star schema, we have snow flake schema which is
more of normalized star schema. Even in snow flake we will
have the fact and dimension only big difference is the
dimension tables are normalized.

Answer / deepa

star schema has fact table in the middle and dimensions
around it which are denormalized.
normalized form of star schema is called snow flake star
schema.

Answer / srikanth nallapati

star schema is a centrelized fact table surrounded by
dimention tables.where dimention tables are denormalized .
here the number of joins are less then the query
performence good.

but in snow flake schema dimention tables are normalized
here we can view lowest level granularity .here the number
of joins are high comparing to snowelake schema then
automatically performence is degread.

Note:performence is depending upon the requirement

Answer / 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

Answer / mohammed

Snowflake is an extension of star schema, where star schema
with each dimension is typically stored in one table.

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

What is a mapplet/worklet in informatica?

0 Answers  

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

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

0 Answers  

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

task is running successfully but data is not loded why?

2 Answers  

How to load duplicate records in to a target table which has a primary key?

2 Answers  

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers