All Forums UDA
shivareddy 3 posts Joined 04/09
17 Apr 2009
performance issues in etl mappings

hi guys,can i know, why the etl jobs/mappings using high cpu utilization?and how can we get multiful data from sourc systems(parallely)?Best RegardsShiva

shri_infa 3 posts Joined 05/09
06 May 2009

Hi shiva,There are various reasons why an ETL mapping can have perf issues1) Source database cud be slw2) Transformation logic cud be flawed4) More look ups or joiners also cause perf issues 3) Target database cud be slwYou can find out perf issues in session logs.For your second question:You can make partitions at session level to load data paralelly.Check partitioning in Infa Help.

shivareddy 3 posts Joined 04/09
07 May 2009

thanking u for ur informaton.......Q:-How we can do benchmarking for ETL processing?may i know,what is the difference b/w performance testing and benchmarking?Regardsshiva

shri_infa 3 posts Joined 05/09
08 May 2009

Shiva,Ur Welcome!!Benchmarking is the process of comparing the cost, cycle time, productivity, or quality of a specific process or method to another that is widely considered to be an industry standard or best practice.As we are discussing about infa here this falls under Product benchmark.Benchmarking means "Fastest possible throughput" and "Highest level of scalability" of Powercenter server if you take Infa into consideration.Perf vs Benchmarking:Perf and benchmarking are interlinked- Performance of an ETL can be scaled against the benchmark.It is simply like scoring systems in our schools where for a subject you can score 100, our score is the performance and 100 is the benchmark.Hope this is helpful.

You must sign in to leave a comment.