Interested to Buy Any Domain ? << Click Here >> for more details...
what is the need of session partitioning... how it is
useful in real time
- 3 Answers
- 8745 Views
- Amazon, I also Faced
- E-Mail Answers
Answer Posted / srinivasm22
It actually enhances the session performance.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What do you understand by SOA of Informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Briefly describe lookup transformation?
What is parallel processing in informatica?
What is the use of code page?
Explain incremental aggregation in informatica
Is there any target staging area in informatica not staging area
How do you load unique records into one target table and duplicate records into a different target table?
Explain how to import oracle sequence into informatica?
What is rank transformation?
What are the popular informatica products?
Informatica Checkpoints
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
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
