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

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,


Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,


What is decode in static cache?

0 Answers  


If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  


what is the difference between repository & Intergration service

1 Answers  






can we use self join in informaitca?

3 Answers   IBM,


What are the different types of repositories created using informatica?

0 Answers  


Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  


What are the different tools in workflow manager?

1 Answers  


what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  


task is running successfully but data is not loded why?

2 Answers  


Slowly changing dimensions, types and where will you use them

0 Answers  


Categories