Answer Posted / n.bandaru
Yes, I agree above answers.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is flashback table ? Advance thanks
What is difference between a gateway node and worker node?
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
How identifying bottlenecks in various components of informatica and resolving them?
How union transformation is used?
Where do we use mapping variables in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
How do you load only null records into target?
Explain about Informatica server process that how it works relates to mapping variables?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to generate sequence numbers without using the sequence generator transformation?
Explain transaction control transformation in informatica
How to extract sap data using informatica?