Answer Posted / satesh kumar

Hello Mukesh,
Can you plz send me the informatica dump.
My mail id:sateeshdonavalli@gmail.com

What are the new features of Power Center 5.0?

1773

---

Explain what transformation and how many are there in informatica?

949

---

Slowly changing dimensions, types and where will you use them

1711

---

Describe the impact of several join conditions and join order in a joiner transformation?

1059

---

Explain Dataware house architecture .how data flow from intial to end?

2580

---

How to create Target definition for flat files?

1215

---

explain one complex mapping with logic? sales project?

6667

---

list out all the transformations which use cache?

1180

---

Define mapplet?

1006

---

can anyone explain me about retail domain project in informatica?

7944

---

State the differences between sql override and lookup override?

1201

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3862

---

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

---

difference between repository database and repository service?

1149

---

Explain scd type 3 through mapping.

997

---