Answer Posted / balakrishna

select empno,name,deptno,loc from emp where rownum=1
                       and
first using sorter select asc,create expression t/r using the variable v_count=v_count+1,o_count=v_count after using the filter t/r to write condition o_count=1 connect filter t/r to target                       
                      and
source--->sq--->seq--->exp--->filter--->target
                      and
select * from emp where rownum=1minusselect * from emp where rownum=2

differences between service based and product based?

2058

---

What is a rank transform?

1146

---

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 ?

2245

---

What is meant by incremental aggregation?

1182

---

How to improve the performance of a session using sorter transformation?

1186

---

What is joiner change?

1191

---

Explain sql transformation in script mode examples in informatica

1209

---

What is dimensional table?

1131

---

How to load the data from people soft hrm to people soft erm using informatica?

1064

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1327

---

What is flashback table ? Advance thanks

1996

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2412

---

without table how to come first record only in oracle?

2301

---

What is resilience time?

1224

---

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

2009

---