none
A simple question about JOIN RRS feed

  • Question

  • Hello!

    I have two agents one is reading a AD database table and the other is reading a HR table.
    The AD table contain SSN short for socialSequrityNumber and firstName, lastName and some more. I have set this SSN as the primary key.
    The HR table contain SocialSecurityNumber, firstName, lastName and some more.
    SocialSecurityNumber is the primary key.
    I have a direct join on SSN with SocialSecurityNumber and if not success I project.
    I have this direct join for both agents.

    In the database I have set firstName to NisseFromAD in the AD table and
    NisseFromHR in the HR table.

    Now I do the following.
    I start with clearing the CS
    Full Import AD (I can see that firstName = NisseFromAD in CS)
    Full Sync AD
    (Now I can see that firstName =NisseFromAD in MV)
    Full Import HR (I can see that firstName = NisseFrom HR in CS)
    Full Sync HR
    (Now I can see that firstName =NisseFromAD in MV)

    My question why is not firstName = NisseFromHR 
    I mean why was it not changed when I run Full Sync HR

    It seems to me that the first agent that is writing to MV will be the owner to the attribute.
    The agent that is comming after can't change it because he is not the owner.

    How can I change so that AD is always the owner to the attribute firstName and lastName so that AD should always override if a value already exist for firstName and lastName in MV.


    //Tony



    • Edited by TojoTojo Friday, August 31, 2018 2:26 PM
    Friday, August 31, 2018 1:29 PM

All replies

  • Hi,

    If you see that you get a join from HR for the object in question, you're probably dealing with a Precedence issue.

    Set HR as the precedent MA (i.e. put it above AD).

    I can also recommend a FIM/MIM Training Course, e.g. from OCG or similar.

    Br,

    Leo


    Did my post help? Please use "Vote As Helpful", "Mark as answer" or "Propose as answer". Thank you!

    Friday, August 31, 2018 2:23 PM
  • Hello!

    Read my previous mail.

    //Tony
    Friday, August 31, 2018 2:32 PM
  • Skip this

    • Edited by TojoTojo Tuesday, September 25, 2018 12:48 PM
    Monday, September 3, 2018 6:22 AM
  • Hello!

    I have two agents one is reading an AD database table and the other is reading a HR table.
    The AD table contain SSN short for socialSequrityNumber and firstName, lastName and some more. I have set this SSN as the primary key.
    The HR table contain SocialSecurityNumber, firstName, lastName and some more.
    SocialSecurityNumber is the primary key.
    I have a direct join on SSN with SocialSecurityNumber and if not success I project.
    I have this direct join for both agents.

    In the database I have set firstName to NisseFromAD in the AD table and
    NisseFromHR in the HR table.

    Now I do the following.
    I start with clearing the CS
    Full Import AD (I can see that firstName = NisseFromAD in CS)
    Full Sync AD
    (Now I can see that firstName =NisseFromAD in MV)
    Full Import HR (I can see that firstName = NisseFrom HR in CS)
    Full Sync HR
    (Now I can see that firstName =NisseFromAD in MV)

    Based on the result I get I say
    that it seems to me that the first agent that is writing to MV will be the owner to the attribute.
    The agent that is comming after can't change it because he is not the owner.

    How can I change so that AD is always the owner to the attribute firstName and lastName so that AD should always override if a value already exist for firstName and lastName in MV.

    //Tony

    Hi Tony,

    Please see Leo`s answer. This is attribute precedence question. After you configure both MA - AD and HR - you must configure each attribute precedence in Metaverse Designer tab.

    AD MA should be the first one and HR is the second in that window.


    Emil Valiev

    Monday, September 3, 2018 7:08 AM
  • Skip this
    • Edited by TojoTojo Tuesday, September 25, 2018 12:48 PM
    Monday, September 3, 2018 7:40 AM