Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Output port and Group by clause in SQ
This is a discussion on Output port and Group by clause in SQ within the Data Warehousing forums, part of the Databases category; Can we create output port in SQ. and Can we write group by clasue in SQ NOTE : [This question was asked by yvreddy]...
|
|||||||
01-04-2007
|
|||
|
|||
|
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 
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| GROUP_BY and HAVING clause in SQL | nancyphilips | SQL | 5 | 09-08-2008 11:39 PM |
| Group Discussions | admin | Site News & Announcements | 52 | 06-16-2008 12:35 AM |
| Output Value | bharathi_ark | Testing Issues | 5 | 12-27-2006 06:13 AM |
| Output Functions | RyanJames | C and C++ | 5 | 12-20-2006 02:10 AM |
| Presence of Clause | nehalshah | MainFrame | 1 | 10-09-2006 03:01 PM |
All times are GMT -4. The time now is 03:56 AM.
