list out all the transformations which use cache?

235

what is the size of u r source(like file or table)?

1385

In informatics server which files are created during the session rums?

223

What is aggregate cache in aggregator transformation?

217

Write the prerequisite tasks to achieve the session partition?

224

How do you load unique records into one target table and duplicate records into a different target table?

201

What are the mapping parameters and mapping variables?

214

What is a grid in Informatica?

223

During the running session, output files are created by informatica server. Enlist few of them.

194

Which are the different editions of informatica powercenter that are available?

189

where to store informatica rejected data? How to extract the informatica rejected data?

199

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

1060

Write the unconnected lookup syntax?

202

What are the static cache and dynamic cache in informatica?

211

Describe expression transformation?

198