Can we create output port in SQ. and Can we write group by clasue in SQ

NOTE : [This question was asked by yvreddy]

Hi
No we cannot create Output ports in Source Qualifiers. They have to be linked to an input port.
Yes, techinically speaking we can do a 'Group By' in Source Qualifier but I would not advice to do so. This is because it makes DB hits to group by . It is better to reall all default data and then group by using a Aggregator transformation.
Cheers
Manisha