Answer Posted / sherriadame

You can get such a training on Informatica PowerCenter
8.1.1 at www.infaservice.com .

They have given a step by step explanation of various
Informatica Administration activities along with visuals.

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

2012

---

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

4152

---

Explain the shared cache and re-cache?

1165

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7184

---

Explain the pipeline partition with real time example?

1200

---

Briefly define reusable transformation?

1184

---

Can we create multiple integration service on single repository?

1242

---

can u any challenge your project?

2085

---

What are the differences between oltp and olap?

1018

---

To import the flat file definition into the designer where should the flat file be placed?

1104

---

Explain the mapping variable usage example in informatica

1224

---

During the running session, output files are created by informatica server. Enlist few of them.

1022

---

Tell me about Propagate functions in informatica

979

---

How do we call shell scripts from informatica?

1191

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2126

---