Answer / krishnendu guha

I believe c1 c2 c3 are the columns

you can override the source qualifier with the following
query

select c1,c2,c3,c4 from table1
union all
select c1,c2,c3,c5 from table1
this should do..

Answer / gunjan singhal

select c1+c2+c3+c4 from table1
union all
select c1+c2+c3+c5 from table1

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

---

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

2 Answers  

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

Define sessions in informatica etl?

0 Answers  

---

What do you understand by SOA of Informatica?

0 Answers  

---

What are the different ways to implement parallel processing in informatica?

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  

---

what is INFORMATICA TESTING process

0 Answers  

---

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

---

Write the different tools in the workflow manager?

0 Answers  

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

what are the perameter and variable?

3 Answers   IBM,

---