Answer Posted / anil

Please send me the dumps at anilkumarhertz@gmail.com.
Thanks in advance.

What is informatica powercenter repository?

1144

---

During the running session, output files are created by informatica server. Enlist few of them.

935

---

How many ways are there to do 'remove duplicate records in informatica'?

956

---

Which transformation should we use to normalise the COBOL and relational sources?

1143

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2022

---

design of staging area?

1966

---

How can we use mapping variables in informatica?

1004

---

Explain the etl program with few examples.

968

---

Make a note of the quantity vaults made in informatica?

945

---

Tell me about MD5 functions in informatica

878

---

What are the types of data warehouses?

1431

---

What are the types of caches in lookup?

978

---

Explain how to import oracle sequence into informatica?

953

---

Briefly explain the aggregator transformation?

943

---

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

1918

---