In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

Answers were Sorted based on User's Feedback



In aggregator transformation, I sort the data before aggregator and select sorted port but still Iâ€..

Answer / ramu

The column which is used as a key prot in sorter should be
the group by port and check box sorted input in aggregator
t/r properties

Is This Answer Correct ?    15 Yes 0 No

In aggregator transformation, I sort the data before aggregator and select sorted port but still Iâ€..

Answer / vasu

Did you select any column for Group by port ?

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,


in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,


hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  


How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  


What is data movement mode in Informatica and difference between them?

0 Answers  






in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  


scd methodology?

2 Answers  


In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,


What are the Differences between static cache and dynamic cache?

1 Answers  


What is lookup transformation?

0 Answers  


what is mapping override?

2 Answers   Cap Gemini,


how to sort date field in infomatica?

2 Answers  


Categories