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
- 1972 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is parameter file?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain the scenario which compels informatica server to reject files?
What the difference is between a database, a data warehouse and a data mart?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
How many number of sessions that u can create in a batch?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
Teradata 
