Interested to Buy Any Domain ? << Click Here >> for more details...
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
2 6690Post New AHM Informatica Interview Questions
-
AHM Informatica Interview Questions (1)
- AHM Law AllOther Interview Questions (1)
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
What are the three types of websites?
What is the use of check integrity?
What dependencies does Bootstrap require for it to work properly?
What are the main features of hdfssite.xml?
Can you run a webdynpro application in background?
How TCP/IP Handles Flow Control?
In update rules for an infocube we can specify separate update rules for characteristics of each of the key figures. In which situations is the above used?
How can governance be extended to all data types?
How does a template instantiated?
Define scheduling in OS.
What is the conditional formatting in excel?
How do you assign an address to an element of a pointer array ?
What are the different input parameters types in sap hana? : hana bi development
draw the diagram of double earthing
