Answer Posted / srinivas

Hi gbalireddy,

There no material for informatica except Informatica help-
contents-


If you want any specialized topics are Other then above
help Pls let me know, I wil try

srinu.srinuvas@gmail.com

How you know when to use a static cache and dynamic cache in lookup transformation?

1791

---

What is a dimensional model?

926

---

How to handle decimal places while importing a flatfile into informatica?

1127

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2060

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1422

---

What are the different transaction levels available in transaction control transformation?

1116

---

What is informatica metadata and where is it stored?

931

---

Under what condition selecting sorted input in aggregator may fail the session?

1056

---

What is an expression transformation in informatica?

962

---

What is a standalone command task?

1133

---

What is incremental aggregation?

1011

---

EXL informatica Questions

1309

---

Clarify the aggregator change?

968

---

What are the issues you have faced in your project? How did you overcome those issues?

2288

---

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

1918

---