Interested to Buy Any Domain ? << Click Here >> for more details...
How can yoU improve session performance in aggregator
transformation?
- 8 Answers
- 27393 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / haritha
use sorted input option to decrease the use of aggregator
cache.
use filter transformation before aggregator transformation
to to rduce unnecessary aggregation.
Limit the number of connected input/output or output ports
to reduce the amount of data the Aggregator transformation
stores in the data cache.
| Is This Answer Correct ? | 39 Yes | 1 No |
Answer / swetha
Use sorted input.
The aggregator stores data in the aggregate cache until it
completes aggregate calculations. When u run a session that
uses an aggregator transformation, the informatica server
creates index and data caches in memory to process the
transformation. If the informatica server requires more
space, it stores overflow values in cache files.
| Is This Answer Correct ? | 13 Yes | 5 No |
Answer / dilip
if you sort the input yet do not select the sorted input
option, the aggregator treats the data as unsorted data &
performs the task hence its cache size increases. the
performance is degraded despite using a sorter.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / chinna
what u guys said is so far ok
but what happen if u have't check the option sorted in
input in aggregator transformation but u actully sorted
before with sorter transformation so what will happen in
agg by performance wise?
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srikanth
hi haritha
u r correct
For using sorted input option, the order of group by ports
in the agg and sorter transfomratoins should be same as
well as the number of ports also same.
we can filter out data early in the morning by using sq
trans rather than using filter before agg hence reducing
unwanted data in teh mapping.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sasmita panda
session performance in aggregator T/R can be increased by
aggregation cache i.e through increamental aggregation.
Aggregation cache has tow caches i)index ii) data.
For first run it performs aggregation calculation in
aggregation cache.Index cache contains group by port
values.Data cache will contain if any variable ports are
created and output port on which we want to implement
aggregate function.
Rowid of last record which is participated in Agg. T/R will
be saved in repository.
During second run it finds the rowid of last record then it
performs increamental aggregation.The integration service
will check the historical information in the index cache
file for corresponding group.If it finds it performs
aggregation operation increamentally. If not finds then it
will adda new port for aggreagtion.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pg
Chinna,
If u have't check the option sorted in
input in aggregator transformation but u actully sorted
before with sorter transformation in that case your session
will fail. You must check the option sorted in
input in aggregator transformation if you are using sorted
input to the aggregator .
Plz let do me know if you still have doubt.
pramodgup@gmail.com
| Is This Answer Correct ? | 6 Yes | 16 No |
Answer / cherry
hi PG
u r absolutely right.
session will fail.
u have to use the check option for sorted input.
| Is This Answer Correct ? | 4 Yes | 14 No |
How many repositories can we create in Informatica?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
What are the performance considerations when working with aggregator transformation?
What are two types of processes that informatica runs the session?
how to load dimension table and fact table. plz tell me the steps.
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
what is the size of u r project? and what is the size of source file?
Please let me know how to make Data masking in informatica..
Why should we use star schema in datawarehouse design?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
Teradata 
