Answer / pal

Yes we can use one mapping to populate data in multiple
schemas.

Answer / sanjay

Use $DBConnection instead of connection in session for
source and change the schema name through the parameter file

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

How do you change parameter when you move it from development to production.

1 Answers  

---

What is a surrogate key?

0 Answers  

---

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

0 Answers  

---

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---

Can we create two repositories on same database instance in oracle?

0 Answers  

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

differences between service based and product based?

0 Answers   Satyam,

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

---

Why we use lookup transformations?

1 Answers  

---

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

---