Answer Posted / vs

I did online informatica training from
staroneconsulting.com for . they were just outstanding and
trainer was brilliant. value for money. I paid 27500 for 40
hours of training . i recommend them whole
heartedly. they are contactible at amit220675@yahoo.com or
at 9810274116

What do you mean incremental aggregation?

1006

---

Explain pmcmd command usage in informatica

1064

---

What is the surrogate key?

1145

---

Where are the source flat files kept before running the session?

1010

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1994

---

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

1081

---

What is a joiner transformation?

935

---

Differentiate between joiner and lookup transformation?

1045

---

What is the fact table?

993

---

Explain joiner transformation in informatica

1071

---

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

---

what are the deliverables?in your project?

2084

---

What is joiner transformation?

942

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2276

---

How is union transformation utilized?

948

---