What is galaxy shema

Answer Posted / b.indu

A combination of star schema and snow flake star schema is known as galaxy schema

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the layout of parameter file (what does a parameter file contain?)?

1890


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

1504


What are the types of lookup transformation?

605


what is size of u r database?

1827


What are the components of workflow manager?

557






What are the restrictions of union transformation?

551


why we are using level option in normalizer transformation

6193


What is mapplet in informatica?

570


What are the databases that informatica can connect to windows?

557


What is meant by lookup transformation?

593


Explain constraint based loading in informatica

635


What is the Rank index port in Rank transformation?

647


whats the logic to load the lower level of granularity of data to fact table.

1764


What is a filter transformation and why it is an active one?

542


How identifying bottlenecks in various components of informatica and resolving them?

560