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

We can achieve better perfomance using sorter before an
aggragator. Then what is the significance of 'Sorted Input'
check in aggregator ?? Please let me know the difference ??

Question Posted / palthepu_santosh

Answers were Sorted based on User's Feedback



We can achieve better perfomance using sorter before an aggragator. Then what is the significance o..

Answer / guest

Typo error in my previous post.

Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the Aggregation Transformation is sorted.

Regards,
Kumar

Is This Answer Correct ?    11 Yes 0 No

We can achieve better perfomance using sorter before an aggragator. Then what is the significance o..

Answer / guest

Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the sorter Transformation is sorted.

Regards,
Kumar

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

Define error Threshold?

1 Answers  

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

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,

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,




In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

What are the different ways to implement parallel processing in informatica?

0 Answers  

what is row level and column level indicator?

1 Answers   TCS,

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers   TCS,

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

How many joins in Informatica

5 Answers   CSC,

For more Informatica Interview Questions Click Here
Categories