- Forum
- Databases
- Data Warehousing - Output port and Group by clause in SQ
-
Expert Member
Output port and Group by clause in SQ
Can we create output port in SQ. and Can we write group by clasue in SQ
NOTE : [This question was asked by yvreddy]
-
Junior Member
Re: Output port and Group by clause in SQ
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules