I cleared Informatica certification Designer. if anybody
need dumps, can contact at mukesh1009@gmail.com
Answer Posted / michael
It's quite possible Mukesh isn't following this thread anymore (but if that's the case why offer the dumps?). I requested them a few posts above your request. I've had no response as of yet, but I remain hopeful.
If anyone else has received them, could you please share?
One other question - does anyone know how frequently Informatica change their certification questions?
Thanks everyone!
Have a great day!
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is rank transformation?
What is a difference between complete, stop and abort?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the use of transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is intricate mapping?
What is the sequence generator transformation in informatica?
Which transformation should we use to normalise the COBOL and relational sources?
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
What are the types of caches in lookup?
What is Cognos script editor?
what are 3 tech challenges/ common issues you face?
What are the performance considerations when working with aggregator transformation?
State the differences between sql override and lookup override?
Parameter and variable differences