Interested to Buy Any Domain ? << Click Here >> for more details...
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall?
Please answer below. thank you.
- 4 Answers
- 8760 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / harish
No performance downfall. Example: if your choosing sort order on deptno asc/desc and sal desc.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why union transformation is an active transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is olap (on-line analytical processing?
wf dont have integration severances how you can run?
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
Reusable transformation and shortcut differences
How can we remove the duplicates from flat file source?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
how many types of dimensions are available in informatica?
What is flashback table ? Advance thanks
can we override a native sql query within informatica? How do we do it?
What is the cumulative sum and moving sum?
wat are deployement groups in informatica, how it will be used for developers
How can you increase the performance in joiner transformation?
How do you load first and last records into target table?
