Results 1 to 6 of 6

Thread: Writing query with LEFT OUTER JOIN

  1. #1
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Writing query with LEFT OUTER JOIN

    Does it work if you write query with LEFT OUTER JOIN (same keyword used in) in SQ trans? (It is sql query override in SQ trans, used 5 tables to join with SQ trans)

    Thx
    SRIRAM N
    Hope Everything Good

  2. #2
    Contributing Member
    Join Date
    Apr 2007
    Answers
    46

    Re: Writing query with LEFT OUTER JOIN

    I will take but make sure database is oracle.


  3. #3
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Re: Writing query with LEFT OUTER JOIN

    Data base is not Oracle ...We are using Teradata

    Thx
    SRIRAM N
    Hope Everything Good

  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Writing query with LEFT OUTER JOIN

    i am not sure of TERADATA.
    please check for the compartible syntax for that database.


  5. #5
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    Re: Writing query with LEFT OUTER JOIN

    Quote Originally Posted by N SRIRAM K View Post
    Does it work if you write query with LEFT OUTER JOIN (same keyword used in) in SQ trans? (It is sql query override in SQ trans, used 5 tables to join with SQ trans)

    Sriram,

    For Teradata, I am not having any approach for this.

    But in informatica, it will not work.

    Sanghala

    If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.

  6. #6
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Re: Writing query with LEFT OUTER JOIN

    No doubt, I tried this it will work in informatica. Thx

    Last edited by N SRIRAM K; 09-07-2007 at 10:13 AM.
    Thx
    SRIRAM N
    Hope Everything Good

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.
Interact