Answer / srinu

Perf Tune is not an simple Question !!!!
its a process !!!

Performance of Informatica is dependant on the performance
of its several components like database, network,
transformations, mappings, sessions etc. To tune the
performance of Informatica, we have to identify the
bottleneck first. Bottleneck may be present in source,
target, transformations, mapping, session, database or
network.
Identify bottleneck in Source
Identify bottleneck in Target
Identify bottleneck in Transformation
Identify bottleneck in sessions
DATABASE OPTIMISATION
OPTIMUM CACHE SIZE IN LOOKUPS


so and so,,,,,,,,,,,,,,,,

Answer / mohanreddybank

First we need to identify the bottlenecks,
Then we need to do peer review

Answer / karthik

Guys we know the bottle necks, but pls tel us how do we
resolve it..

for example :

if source is reading the date very slowly, how do we solve
that??

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

Define Pmrep command?

0 Answers  

---

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

0 Answers  

---

when informatica 8 series released ?

1 Answers   IBM,

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

What all join we can perform in LOOKUP transformation?

0 Answers  

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

Describe expression transformation?

0 Answers  

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

how to declare array in plsql?

1 Answers  

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---