What is ThroughPut in Informatica, How it works, Where I
can find this option to check ?
Answer Posted / sri
Deepti,,,Thanks,,,
Thoughtput gives Records data in (no of Bytes per sec or
no of rows per sec).?
How can i find 1byte= __rows ?
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is main use of mapplet?
What are the uses of etl tools?
What is the different lookup cache(s)?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping 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
What are different types of transformations available in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to go to the older version for a mapping?
How to create a non-reusable instance of reusable transformations?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Explain the difference between mapping parameter and mapping variable?
What is the Rank index port in Rank transformation?
How to use pmcmd utility command?
What is option by which we can run all the sessions in a batch simultaneously?
What is dynamic cache?