Results 1 to 8 of 8

Thread: A typical scenario with Joiner....!

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    A typical scenario with Joiner....!

    All,

    How can you join three tables at a time?
    Why can't we use a Single Joiner Transformation to join three tables at a time ?

    Sanghala


    Sanghala

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

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

    Re: A typical scenario with Joiner....!

    Two join three tables (which are originated from same database) then use single source qualifier transformation.

    If they are not homogeneous sources then use two different joiner transformations.

    Really good question(requirment) to Informatica Tech Support, Please ask them to ease them in the next version.

    TAKE IT EASY

    Thx
    SRIRAM N
    Hope Everything Good

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

    Re: A typical scenario with Joiner....!

    Quote Originally Posted by N SRIRAM K
    Two join three tables (which are originated from same database) then use single source qualifier transformation.

    Really good question(requirment) to Informatica Tech Support, Please ask them to ease them in the next version.
    Yep this Question was atlleast not updated by any one as i have asked many of my friends.

    Quote Originally Posted by N SRIRAM K
    If they are not homogeneous sources then use two different joiner transformations.
    But I donot want to use multi Joiner Transformations

    But in Infa 7.1 version, some option is there to do this.

    Let me get it by reading the Help of Infa itself..........!

    Last edited by admin; 05-31-2013 at 07:22 AM.
    Sanghala

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

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

    Smile Re: A typical scenario with Joiner....!

    I will try from my side.

    Let me know if you get it.

    Thanks.......................

    Thx
    SRIRAM N
    Hope Everything Good

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

    Re: A typical scenario with Joiner....!

    Quote Originally Posted by N SRIRAM K
    I will try from my side.
    Let me know if you get it.
    As per my investigation, This is done by CUSTOM Transformation which is available from INFA 7.1 version.

    If it is not correct.... Please make it perfect...!



    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: A typical scenario with Joiner....!

    G R E A T. I thought its not possible but you did it.
    Its great help if you explain.............Thx

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

  7. #7
    Junior Member
    Join Date
    Oct 2010
    Answers
    4

    Re: A typical scenario with Joiner....!

    You can join the three tables using Joiner transformation proivded that the condition should be mention in Joiner properties


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