Answer Posted / balaji.m

Do one thing Upgradation of repository means u can upgrade
the lower version into higher version tis u can do in
Repository Manager right click on that there is the option
upgrade select that and then add the licence & product
code......

How to generate sequence numbers without using the sequence generator transformation?

1212

---

What are the different versions of informatica?

1276

---

What is mapping debugger?

1021

---

How to elaborate powercenter integration service?

1137

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1109

---

Can anyone tell me the new features in Informatica 9 Version?

2133

---

What does command task mean?

1155

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4112

---

How will the document be delivered to me?

1085

---

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

1970

---

Explain the types of transformations?

1071

---

How to do the error handling of if ur source is flatfiles?

1969

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1956

---

What is a shortcut and copy in Informatica and how two are different with each other?

1199

---

Explain lookup transformation in informatica

1080

---