1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

I have 1200 records how can u send it in aggregator with
good performance issues?

Question Posted / shravan.cap

Answers were Sorted based on User's Feedback



I have 1200 records how can u send it in aggregator with good performance issues?..

Answer / kishore

Before aggrgator transformation it's better to use Sorter
transformation, which will make them as sort, which will
increse the performance.

Is This Answer Correct ?    7 Yes 0 No

I have 1200 records how can u send it in aggregator with good performance issues?..

Answer / drk

By using sorted input and group by function ,we can overcome
the performance issues

Is This Answer Correct ?    3 Yes 0 No

I have 1200 records how can u send it in aggregator with good performance issues?..

Answer / venkat

Provide sorted input before aggregation.
->Override default Sql from source Qualifier if the source
is relational-Use order by clause
(OR)
->Use Sorter transfermation to do the same

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the challenges of Dataware housing in the future?

2 Answers   HP,

How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,

What is informatica worklet?

0 Answers  

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

explain about session partitions ?

1 Answers  




What are the types of presistent cache in look up tr.

0 Answers   IBM,

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 Answers   Deloitte,

For more Informatica Interview Questions Click Here
Categories