Can we create output port in SQ. and Can we write group by clasue in SQ
NOTE : [I][This question was asked by yvreddy][/I]
Printable View
Can we create output port in SQ. and Can we write group by clasue in SQ
NOTE : [I][This question was asked by yvreddy][/I]
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