How to improve the performance of Aggregate
transformation?

Answer Posted / uzval_vee

Place the agg transformation after souce qualifier,becoz
if yur using filter,sorting before agg ,it will reduce the
agg performance .according to my view

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is union transformation in informatica?

695


What is the command used to run a batch?

572


How do you migrate data from one environment to another?

641


How to partition the Session?

641


How do you load unique records into one target table and duplicate records into a different target table?

705






What do you mean by channel change?

537


what are the Methods For Creating Reusable Transformations?

647


Did u used latest transformations of 8.6.0? for what?

1473


Explain sessions and how many types of sessions are there?

578


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1550


Define mapplet?

624


permutations of mapplet

2038


What are active and passive transformations?

647


What is sq transformation?

658


What is dimensional table?

617