Interested to Buy Any Domain ? << Click Here >> for more details...
what are cost based and rule based approaches and what is
the difference?
- 1 Answers
- 5546 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalpana
costbased and rule based approaches r used as optimization
techniques in improving the performance of queries
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to load dimension table and fact table. plz tell me the steps.
4 yrs etl devloper roles and responsibilities?any body give solutions
How to differentiate between the active and passive transformations?
How to do the error handling of if ur source is flatfiles?
How union transformation is used?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How might you approve all mappings in the archive all the while?
r u done any partitions in ur project?
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.
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
EXL informatica Questions
difference between informatica 8.1.1 and 8.6
What are the prerequisite tasks to achieve the session partition?
Does an informatica transformation support only aggregate expressions?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
