Results 1 to 3 of 3

Thread: Scenario on Update strategy..?

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

    Scenario on Update strategy..?

    Assume that mapping have Update Strategy Transformation where all rows are marked for ‘Update’. In session configuration, - “Treat Rows as” is set to “Insert” and target option is “Update (else insert)”. How Informatica will treat the rows?

    Thanks in Advance
    Sanghala
    sanghala
    dwforum.sanghala

    Last edited by admin; 06-21-2012 at 10:11 AM.
    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: Scenario on Update strategy..?

    Generally, the transformation properties override by the session properties. So Mapping(transformation) property UPDATE won't work.
    Session property will flag all the inputs rows as INSERT.
    Then The TGT property UPDATE else INSERT then the PowerCenter Server updates rows flagged for update if it they exist in the target, then inserts any remaining rows marked for insert.

    Thx
    SRIRAM N
    Hope Everything Good

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

    Smile Re: Scenario on Update strategy..?

    Quote Originally Posted by N SRIRAM K View Post
    Generally, the transformation properties override by the session properties. So Mapping(transformation) property UPDATE won't work.
    Session property will flag all the inputs rows as INSERT.
    Then The TGT property UPDATE else INSERT then the PowerCenter Server updates rows flagged for update if it they exist in the target, then inserts any remaining rows marked for insert.

    Sriram,

    Thanks a lot for your valuable inputs...
    Finally you will say that - Update else Insert will work for this scenario.

    sanghala

    Last edited by admin; 06-21-2012 at 10:12 AM.
    Sanghala

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

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