Answer Posted / xxx

Using Unconnected LKP transformation

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2108

---

In informatica workflow manager, how many repositories can be created?

1338

---

What are connected or unconnected transformations?

1102

---

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

1957

---

What is workflow manager?

1030

---

What is main use of mapplet?

1124

---

Difference between Data and Index Caches?

1127

---

What is deployment group?

1189

---

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

1185

---

Explain the types of transformations?

1052

---

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

2506

---

How big was your fact table

1787

---

What is the meaning of decode in informatica?

1109

---

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

1975

---

Explain the difference between mapping parameter and mapping variable?

1024

---