Answer Posted / sujatha

Hi,
First declare mapping variable like $$rec_load in mapping tab under parameters/variables.

next in expression transformation declare one port like rec_count=setvariable($$rec_load,$$rec_load+1000)

first time $$rec_load having value zero.next time it will load 1000 records like that every run it will increment 1000 records.

Is there any way to read the ms excel datas directly into informatica?

1012

---

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 ?

2163

---

State the limitations where we cannot use joiner in the mapping pipeline?

1042

---

What is substr in informatica?

1179

---

What is persistent lookup cache?

1012

---

What differs when we choose the sorted input for aggregator transformation?

1004

---

Design time, run time. If you don't create parameter what will happen

1826

---

Can we create multiple integration service on single repository?

1172

---

Implementation methodology

1694

---

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

1954

---

Mention few advantages of router transformation over filter transformation.

1019

---

Where do we use mapping variables in informatica?

1043

---

How do you load alternate records into different tables through mapping flow?

1836

---

lookup transformation with screenshots

3984

---

What are the uses of etl tools?

1111

---