My source contains 10 records with 5 columns.What happens if I
select group by all columns in Aggregator T/R?

Answer Posted / rayudu

If you select groupby on all the ports you will get distinct records only.

Is This Answer Correct ?    22 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define mapplet?

627


What are the differences between oltp and olap?

552


differences between service based and product based?

1566


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1019


How many types of sessions are there in informatica.please explain them?

678






What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

794


Write the different tools in the workflow manager?

575


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

742


What is powercenter on grid?

698


What is the use of source qualifier?

674


Why update strategy and union transformations are active?

594


Mention some types of transformation?

607


What is olap (on-line analytical processing?

646


what are 3 tech challenges/ common issues you face?

1892


design of staging area?

1591