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
- 17080 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / krishna
also a rank Xmation uses cache
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is incremental aggregation?
Where can we find the throughput option in informatica?
What are the advantages of informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
what is size of u r database?
What are session parameters ? How do you set them?
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 is meant by incremental aggregation?
How can we update a record in the target table without using update strategy?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
is it possible to index the data in cache of lkp transformation ?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How would you join a node to the already existing domain?
What do think which one is the better joiner or look up?
