Answer Posted / meera
creating copies takes extra memory. it is anlaogus to have a complete duplicate of the mapping. whereas shortcut refers to the refrence for the mapping. when creating shortcut memory is not used up . and any change made to the original reference (mapping) will be reflected in the shortcut.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you load first and last records into target table?
How do you load unique records into one target table and duplicate records into a different target table?
Where are the source flat files kept before running the session?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can u generate reports in Informatica?
How to partition the Session?
How do you set a varible in incremental aggregation
What is a joiner transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is data transformation manager process?
explain about unit testing? in real time?
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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
