Results 1 to 5 of 5

Thread: File having 12 records I have to send data to different targets

  1. #1
    Junior Member
    Join Date
    Jun 2007
    Answers
    7

    File having 12 records I have to send data to different targets

    Plz give the answer. If a file having 12 records shown below. I have to send empno(1,2,3) send to one target, empno(null) send to 2nd target, empno(4,4,4) send to 3rd target, empno(5,5,5) send to 4th target.

    empno
    1
    2
    3
    null
    null
    null
    4
    4
    4
    5
    5


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

    Re: File having 12 records I have to send data to different targets

    By using Router transformation of the informatica u can do this.
    in router u can give these three condition and defined ur target in user defined output group.on the behalf of the condition the records will move to the target.


  3. #3

    Re: File having 12 records I have to send data to different targets

    Try it will work fine:-


    Use Router transformation by giving different condition as per ur requirement for each target.

    cheers

    Last edited by Rksinghpathania; 06-28-2007 at 03:04 AM.

  4. #4

    Re: File having 12 records I have to send data to different targets

    Quote Originally Posted by rasmi View Post
    Plz give the answer. If a file having 12 records shown below. I have to send empno(1,2,3) send to one target, empno(null) send to 2nd target, empno(4,4,4) send to 3rd target, empno(5,5,5) send to 4th target.

    empno
    1
    2
    3
    null
    null
    null
    4
    4
    4
    5
    5
    Try it will work fine:-

    Use Router transformation by giving different condition as per ur requirement for each target.

    bye


  5. #5
    Noel Lastra
    Guest

    Re: File having 12 records I have to send data to different targets

    Hello guys, just my two cents:

    In informatica that is the best solution, the use of router transformation and setting different conditions. Otherwise, you can use or create a procedure that's decode's each condition ... which is a bit more tricky.


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