Results 1 to 3 of 3

Thread: I want to load odd number records into one target table

  1. #1
    Junior Member
    Join Date
    Feb 2007
    Answers
    4

    I want to load odd number records into one target table

    Hi friends, my question is
    I have 100 records in a source flat file. I want to load odd number records into one target table & even number records into another target table.
    Using Informatica how can we do this ?
    Thanks inadvance.


  2. #2
    Junior Member
    Join Date
    Apr 2007
    Answers
    4

    Re: I want to load odd number records into one target table

    use a router transformation and groups with even and odd

    for even records give a condition id%2=0
    odd records id%2>0
    this my idea if id is number.Try it if it not works try anther expression on which column based u want to split that records ok


  3. #3
    Junior Member
    Join Date
    Feb 2007
    Answers
    4

    Re: I want to load odd number records into one target table

    Hi Jagadishwar,
    Thanks for your reply.

    I used some other condition i.e mod(num,2)=0 for even number in router transformation. Its working.
    num is the column created to hold the serial number, and are generated using sequence generator transformation.

    According to your answer, can we use rowid in any expressions for flat files?


    Thanks & Regards,
    G Gopi Krishna.





    Quote Originally Posted by jagadishwar View Post
    use a router transformation and groups with even and odd

    for even records give a condition id%2=0
    odd records id%2>0
    this my idea if id is number.Try it if it not works try anther expression on which column based u want to split that records ok



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