Answer Posted / sweta

Hi Mukesh,

Can u pls send me the informatica certification dumps ASAP.
Even i m planning to do the certification within a month.

Thanks

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

1968

---

What the difference is between a database, a data warehouse and a data mart?

1151

---

Is there any target staging area in informatica not staging area

2577

---

Scheduling properties,whats the default (sequential)

1952

---

What is informatica worklet?

1061

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2034

---

What is informatica metadata and where is it stored?

989

---

What is a stored procedure transformation?

1051

---

How to improve the performance of a session using sorter transformation?

1144

---

What is informatica?

1150

---

Mention few power centre client applications with their basic purpose?

946

---

What could be the possible resons of locks by user?

1091

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1121

---

How might you approve all mappings in the archive all the while?

1016

---

What is repository manager?

984

---