Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shaheem qhizer
Example of time dimension is Calender year.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Explain your project of banking domian.
What is a snowflake schema?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Slowly changing dimensions, types and where will you use them
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What do you mean incremental aggregation?
How to extract the informatica rejected data?
How are the sources and targets definitions imported in informatica designer?
Can we create two repositories on same database instance in oracle?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Can you generate sequence numbers without using the sequence generator transformation?
What are the designer tools for creating transformations?
what is the Default Source Option For Update Strategy Transformation?
What the difference is between a database, a data warehouse and a data mart?
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
