Answer Posted / sunil

hi, my name is sunil.
please send me the dumps for "informatica certified
designer" to my mail id: sunilguptamait@gmail.com

Thanks

What are the advantages of using informatica as an etl tool over teradata?

1028

---

How to generate sequence numbers without using the sequence generator transformation?

1213

---

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

1971

---

what is SDLC way of code development?

2046

---

How to generate sequence numbers?

1095

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2525

---

In which transformation you cannot drag ports into it?

1323

---

What is a rank transform?

1092

---

What is domain in terms of informatica?

1010

---

What is joiner change?

1152

---

tell me 5 session failure in real time how can you solve that in your project?

2306

---

Explain the shared cache and re-cache?

1124

---

What are the uses of etl tools?

1131

---

What is a stored procedure transformation?

1059

---

What are data-driven sessions?

1219

---