Answer Posted / rohan

Hi Mukesh,

Can u pls send me the informatica certification dumps to
frn4u1@rediffmail.com .I am also planning for the exam ..

Thanks

explain one complex mapping with logic? sales project?

6590

---

How would you join a node to the already existing domain?

1065

---

What is joiner change?

1077

---

How do you handle two sessions in Informatica

1070

---

Explain the scenario which compels informatica server to reject files?

1084

---

What are roles and groups and benefits of using them?

988

---

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

1917

---

What are the differences between joiner transformation and source qualifier transformation?

1094

---

Differentiate between sessions and batches?

962

---

What is decode in static cache?

1074

---

How to create or import flat file definition in to the warehouse designer?

1018

---

Explain constraint based loading in informatica

1034

---

what is INFORMATICA TESTING process

2223

---

What is a repository? And how to add it in an informatica client?

1080

---

Explain in detail scd type 2 through mapping.

985

---