Answer Posted / sudhar

Pushdown optimization is used to push the complex logic to
the database level. This will reduce the complexity of the
Powercenter mappings and increases the performance.

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5786

---

How to do unit testing in informatica? How to load data in informatica ?

1116

---

what is diff b/t sorter t/r and agg have the option sorter property...

2169

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

---

What are the main issues while working with flat files as source and as targets ?

1150

---

What are the new features of Power Center 5.0?

1770

---

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

1967

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2035

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1104

---

What are the new features of informatica 9.x developer?

968

---

Explain informatica architecture - version 8 / 9

1085

---

what is INFORMATICA TESTING process

2287

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2159

---

Explain why we use partitioning the session in informatica?

1086

---

How to extract sap data using informatica? What is abap? What are idocs?

1176

---