Answer Posted / vishnu_kr

Hi,

i guess the SQL override is used in the source qualifier trf
to implement joins, filter, sorter etc..

but update override is used in the Target table definition.
u use this option to update Targets that have no primary
key (hence u can't use update strategy) coupled
with 'Update as update' property in the session mappings tab
and 'Treat rows as' property set as 'Update' in the session
Properties tab.

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

1968

---

What are mapplets?

1265

---

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

1423

---

Write the unconnected lookup syntax?

1082

---

Explain informatica architecture - version 8 / 9

1087

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2119

---

Define enterprise data warehousing?

1200

---

What does refresh system mean, and what are its distinctive choice?

1169

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1790

---

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

2354

---

wf dont have integration severances how you can run?

1938

---

Which are the different editions of informatica powercenter that are available?

1034

---

Explain what is informatica metadata and where is it stored?

1049

---

explain one complex mapping with logic? sales project?

6667

---

How do you migrate data from one environment to another?

1094

---