Answer Posted / chandra

override source qualifier
SELECT E.* FROM(SELECT ENAME,SAL,ROWNUM R FROM EMP) E WHERE
R IN (1,5);
HERE I TAKE EMP TABLE

What are the types of presistent cache in look up tr.

2028

---

How to join three sources using joiner? Explain though mapping flow.

1112

---

What is an Integration service in Informatica?

1106

---

explain one complex mapping with logic? sales project?

6627

---

What is the use of code page?

1038

---

Differentiate between Load Manager and DTM?

2111

---

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

1942

---

Differentiate between joiner and lookup transformation?

1066

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2147

---

Is it possible to use a client with different version than that of its Informatica server?

1097

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2160

---

What is the difference between Active and Passive transformation?

1103

---

Make a note of the quantity vaults made in informatica?

956

---

How to handle decimal places while importing a flatfile into informatica?

1150

---

What's the layout of parameter file (what does a parameter file contain?)?

2353

---