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's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg

0 Answers  

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

Issue with Update override at Target table in Informatica.

2 Answers  

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers