Interested to Buy Any Domain ? << Click Here >> for more details...
whether Sequence generater T/r uses Caches? then what type
of Cache it is
- 7 Answers
- 17091 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / chaitanya
Yes sequence generator uses Cache in case of reusable.
This cache is used to buffer the max no of seq no that can
be generated for each execution.
For more details plz refer Informatic 8.1 manual.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
Briefly explain the aggregator transformation?
How can we use batches?
Enlist the tasks for which source qualifier transformation is used.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are 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 main use of mapplet?
What are the various types of transformation?
Global and Local shortcuts. Advantages.
Different qualification between a related rotate toward the sky and isolates look upward?
What if the source is a flat-file?
What is a predefined event?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to open an older version of an object in the workspace?
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
