Friday, June 17, 2011

Having some cols in Aggregator and not given 'Sorted Input' as checked and we done GroupBy . What will happen? Whether it sorts the data first and do group by.. or ..directly do groupby.

      If your incoming data is in sorted manner and if we forgot to enable the option in Aggr-tr, then Integ serv still treates the rows as unsorted, and try to scan from the first Record onwards. It will sorts the data in the Group By port and next does Grouping..

     For example we have NAMES column which contains alphabet names, and we checked on group by on NAMES, then it will sorts the data first and does group by with corresponding columns.

SID      SNAME
1        Ram
1      Pothina
2      Anil
2      Kumar
  3      Doppal

In this above example .. if we do Group by on SNAME…It will sorts the names and then does Group By..

2              Anil
3              Doppal
2              kumar
1              Pothina
1              Ram



-- Ram

4 comments:

  1. Informatica Online Training | Informatica Online Training in India Hyderabad | Best Informatica Online Training
    Informatica Online Training I have taken this course from Attain Technologies. Thay covered all the real time scenarios and their training way was very good approach is very much understandable
    Contact them on given contact number is +91 9052820000, +1 2092073642, Email:contact@attainonlinetraining.com
    Web: http://attainonlinetraining.com/it-informatica-online-training.html

    ReplyDelete
  2. It was so nice article and useful to Informatica learners. we also provide Informatica Course online training our Cubtraining is leader in providing Software Training

    ReplyDelete
  3. Great stuff.
    Informatica Training in Bangalore,Informatica Training,Informatica Online Trainiing.

    http://www.tekclasses.com/

    ReplyDelete