Results 1 to 2 of 2

Thread: Create Multiple rows from single row - informatica

  1. #1
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    512

    Create Multiple rows from single row - informatica

    My source data is in the denormalized format which is shown below:

    Code:
    Student, subject1, subject2
    ---------------------------
    A, Maths, Physics
    B, Science, Social
    I want to normalize the data and print the subjects taken be each student in separate rows. The output is shown below:

    Code:
    student, subject
    ----------------
    A, Maths
    A, Physics
    B, Science
    B, Social

    How can i implement the mapping logic to get the above output.

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    512
    Use the normalizer transformation:

    SRC->SQ->NORMALIZER->TGT

    Open the normalizer transformation, click on the normalizer tag and create two ports,

    Code:
    Port ,   occurs
    ----------------
    student, 1
    subject, 2
    Now connect the SQ student, subject1 and subject2 ports to normalizer transformations student_in, student_in1 and student_in2 ports respectively.

    Connect the Normalizers student and subject ports to target ports.

Similar Threads

  1. Replies: 0
    Last Post: 12-29-2012, 06:33 AM
  2. Replies: 0
    Last Post: 12-20-2012, 02:35 PM
  3. Replies: 0
    Last Post: 07-05-2012, 06:24 AM
  4. Replies: 1
    Last Post: 06-01-2012, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •