Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1946 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how to connect two or more table with single source qualifier?
In warehouses how many schemas are there?
What are the databases that informatica can connect to windows?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
how much memory (size) occupied by a session at runtime
What is difference between a connected look up and unconnected look up?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
What do you mean by channel change?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
What does refresh system mean, and what are its distinctive choice?
Teradata 
