What is the difference between a shortcut of an object and copy of an object? Compare them.
Answer Posted / rj
in case of shortcut u cant make any change in it directly.U need to make the change in the original object .while in case of copy the change will get reflected in the original object if u make any change in the copied object.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Where is metadata stored?
What is the Rank index port in Rank transformation?
How can we handle two sessions in informatica?
Quickly characterize reusable change?
Explain sessions and how many types of sessions are there?
What is the use of transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How many ways a relational source definition can be updated and what are they?
What is complex mapping?
What is a rank transform?
What are ETL Tools?
Explain the informatica workflow?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What do you understand by SOA of Informatica?
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