Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pawan
Test Load is an option at session level.Enabling this option provides an option for debugging & dry run of informatica codes without any (impacts) commit in target tables. Number of rows for dry run/testing can also be specified .By default its 1.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a rank transform?
What are connected or unconnected transformations?
Define Pmrep command?
What is the use of transformation?
How to do unit testing in informatica?
Enlist few areas or real-time situations where informatica is required.
How does a sorter cache works?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is data caches/ index caches?
Why update strategy and union transformations are active?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Explain load alternative records / rows into multiple targets - informatica
Tell me about Propagate functions in informatica
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
