Results 1 to 2 of 2

Thread: Output port and Group by clause in SQ

  1. #1
    Expert Member
    Join Date
    Oct 2006

    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]

  2. #2
    Junior Member
    Join Date
    Dec 2006

    Re: Output port and Group by clause in SQ

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.