Answer Posted / rekha
U CAN USE SHOTCUTS WITH IN THE MAPPING WHERE AS REUSABLE
OBJECTS U CAN USE ACROSS MAPPINGS OF THE EPOSITORY
Is This Answer Correct ? | 0 Yes | 12 No |
Post New Answer View All Answers
What is a code page?
What is the procedure for creating independent data marts from informatica 7.1?
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 will be the approach?
What is the session task and command task?
Where is metadata stored?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is the difference between informatica6.1 and infomatica7.1
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
In informatica workflow manager, how many repositories can be created?
What is an unconnected transformation?
What is primary and backup node?
What is lookup transformation?
Where do we use mapping variables in informatica?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?