Results 1 to 6 of 6

Thread: Identify New Records

  1. #1
    Junior Member
    Join Date
    Mar 2008
    Answers
    2

    Identify New Records

    Hi,

    Any one please answes to my question.

    Today i have inserted some records in target.If i come tomorrow some more records are present in source table.

    How can i identify those new records and i need to insert only those records which are new.

    I am new to informatica tool.Please help me in this regards

    Thanks
    Raj


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

    Re: Identify New Records

    Hi,

    You can use lookup transformation to identify the records presents in the target table.
    here target table will be lookup table.after that you can put one router to insert/update new records

    Thanks
    Reeta


  3. #3
    Junior Member
    Join Date
    Jan 2008
    Answers
    15

    Re: Identify New Records

    i could not understand ..could u plz. explain once again..???


  4. #4
    Junior Member
    Join Date
    Mar 2008
    Answers
    15

    Re: Identify New Records

    Do a lookup on target table with its primary key.If row already exists then update else insert...This can be done using a router transformation and an update strategy transformation.


  5. #5
    Junior Member
    Join Date
    Mar 2008
    Answers
    2

    Re: Identify New Records

    Quote Originally Posted by rajpandu View Post
    Hi,

    Any one please answes to my question.

    Today i have inserted some records in target.If i come tomorrow some more records are present in source table.

    How can i identify those new records and i need to insert only those records which are new.

    I am new to informatica tool.Please help me in this regards

    Thanks
    Raj
    Hi
    is there any field with date in source.
    If it is then write SQL overide in SQ to get the new records from source.


  6. #6
    Junior Member
    Join Date
    Sep 2007
    Answers
    13

    Re: Identify New Records

    Just use a update transformation and give the option dd_update in Update strategy expression, when u run it new records get inserted or old ones get updated. I dnt think there is a need for lookup and all to just load new records.


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