Results 1 to 2 of 2

Thread: Load N no of files in target in one session

  1. #1
    Junior Member
    Join Date
    May 2007
    Answers
    9

    Load N no of files in target in one session

    Please let me know how to load N no of files in target in one session ie not seprately

    I have 5 flat files having same structure and i want to load them in the target in one job
    The solution suggested was:
    ********************************************************************
    As you have told, There are 5 files which should be processed at a time.


    Keep the Path of these 5 files in a file.

    Then come to Informatica Workflow designer, create the session for this.


    In Session properties, Goto Mappings tab ---> select Sources
    In Source properties, under File Reader tab

    Select the following as -
    Source File directory - {Provide the path of the file containing the path of 5 files}
    Source file name - {Provide the file name of the file containing the path of 5 files}
    Source type - Indirect


    By execution of this session, It will process the 5 flat files at a time.
    *********************************************************************
    But my question is, in mapping designer what will be source and what will be the target
    and you will link source and target


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

    Post Re: Load N no of files in target in one session

    @Ramesh -

    Firstly, you asked abt the source - it will be the directory of flat-files and target - where you want to load these data ( for Eg - xyz_table).

    Then mapping is similar to flatfile - target loading.
    Hope this is helpful for you...

    Secondly,

    Please specify source (link) from where you have got this information - so that somebody groan you that you copied the info from somewhere and pasted here.


    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