Skip navigation
Contact Us
1704 Views 4 Replies Latest reply: Nov 8, 2012 8:42 PM by Ramakrishna B.V.S. RSS
fardeen khan Apprentice 129 posts since
Dec 10, 2009
Currently Being Moderated

Oct 30, 2012 12:19 AM

Joiner Transformation issue?

Dear Friends,

 

I want to join 2 tables using joiner transformation and even i need to capture the null values , how can i do that? Does joiner transformation capture null vales by default?

  • Veeru B Master 1,242 posts since
    Sep 27, 2010
    Currently Being Moderated
    Oct 30, 2012 7:41 AM (in response to fardeen khan)
    Joiner Transformation issue?

    Hi Fardeen,

     

    As per my understanding any null not equal to null (in informatica as well as Oracle). So even if you pass null values for join condition in informatica it will not find any matching and filter that record.

     

    If you want null records out put from joiner the use expression transformation before joiner and convert null with some default value in both pipe lines.

     

    Regards,

    Veeru

  • nithya shanmugam Novice 58 posts since
    Jan 11, 2012
    Currently Being Moderated
    Nov 7, 2012 11:30 PM (in response to fardeen khan)
    Joiner Transformation issue?


    Hi Faradeen,

     

     

    I tried up with  the below example.

     

     

    i/p

     

    Table A:                                   Table  B:

     

    id   name                                  id  role

    1    Abi                                     1   manger

    2    null                                     2   null

     

     

    o/p

     

     

    Id    name   Role

     

    1  Abi       manager

    2  null      null

     

     

     

    i/p

     

    Table A:                                   Table  B:

     

    id   name                                  id  role

    1    Abi                                     1   manger

    2    null                                     2   null

     

     

    i/p

     

    Table A:                                   Table  B:

     

    id   name                                  id  role

    1    Abi                                     1   manger

    0    banu                                   0   SE

     

     

    O/P

     

    Id name role

     

    1 abi    manager

    0 banu SE

     

     

    i/p

     

    Table A:                                   Table  B:

     

    id     name                                  id     role

    1      Abi                                     1      manger

    null   null                                     null   null

     

     

    o/p:

     

     

    id    name   role

     

    1   abi  manager

     

     

     

     

    These are the three o/p i got in result.

     

    If you give everything as null,it wont return any value.

     

    Regards,

    Nithya S.

  • Ramakrishna B.V.S. Novice 55 posts since
    Jul 25, 2010
    Currently Being Moderated
    Nov 8, 2012 8:42 PM (in response to fardeen khan)
    Joiner Transformation issue?

    Hi fardeen khan,

     

    As  Veeru said,

    null not equal to null (in informatica as well as Oracle). So even if  you pass null values for join condition in informatica it will not find  any matching and filter that record.

     

    If you need to capture the null values means, you want to cature Total records (non matching also), so why don't you use Full Outer JOin.

     

    Regards,

    B.V.S.Ramakrishna

More Like This

  • Retrieving data ...

Bookmarked By (0)