Answer Posted / srikanth
A cache is a memory area where informatica server holds the
data to perform calculations during the session. It
creates cache files in the $PMcachedir and as soon as the
session finishes, server deletes the cache files from the
directory.
if we know the data does not change between session runs,
we can persist on the disk (persistent cache ) and use
those files in other sessions. in this case, the server
does not delete the cache files as soon as the session
finishes.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain pushdown optimization and types in informatica
What are the different transaction levels available in transaction control transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the new features of Power Center 5.0?
What is the cumulative sum and moving sum?
What are the transformations that are not supported in mapplet?
What is olap (on-line analytical processing?
Differences between connected and unconnected lookup?
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 you know about transaction control transformation?
what is song in infrmatica...?
What is blocking transformation?
How to implement security measures using repository manager?
How to go to the older version for a mapping?
What is informatica worklet?