Answer Posted / chandu.sev

Hi mukesh,

can you please email me the dumps at chandu.sev@gmail.com.

thanks in advance for your help

What is the benefit of partitioning a session?

1175

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8197

---

What is the need of an ETL tool?

1083

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1987

---

What are the features of complex mapping?

1152

---

What is an active transformation?

1096

---

Slowly changing dimensions, types and where will you use them

1710

---

permutations of mapplet

2509

---

how to load rows into fact table in data warehouse

1181

---

Mention few power centre client applications with their basic purpose?

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

1968

---

what is the size of your data warehousing?

2091

---

How we can create indexes after completing the loan process?

1203

---

What are the settings that you use to configure the joiner transformation?

1051

---

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

3861

---