Results 1 to 5 of 5

Thread: Append data to a target file

  1. #1
    Expert Member
    Join Date
    Oct 2006

    Append data to a target file

    In Informatica, How to append data to a target file?

    NOTE : [This question was asked by Ramakrishna, I am posting it in proper forum]

  2. #2
    Junior Member
    Join Date
    Dec 2006

    Re: Append data to a target file

    I am not sure if this is the best possible way , but just a suggestion.
    Write a new target file and then in the post session command concat / append to the master file.

  3. #3

    Re: Append data to a target file

    It's going to be a long way depending on your extraction requirements, like cleansing, scrubbing etc. However, if you through with this process and ready to append the records in your target area then from your cleansed records (after the expression, joiner, lookup etc.). Inside the mapping you can link the ouput ports of your last transformation going to the input ports of your STG or target definition.

  4. #4
    Noel Lastra

    Re: Append data to a target file

    sorry, just to add up, make sure you configure your session properties, instance, connections, treat source file as, something like that. then you need to run the workflow.

  5. #5
    Junior Member
    Join Date
    Jul 2010

    Re: Append data to a target file

    by using data_driven commands u can append data to target

  6.  Sponsored Ads


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.