Results 1 to 2 of 2

Thread: Load unique and duplicate records into multiple targets - Informatica

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

    Load unique and duplicate records into multiple targets - Informatica

    In one of my project, I am getting data in a source file daily. One of the field contains duplicate values. The data in the file is shown below:

    Code:
    value
    --------
    A
    B
    C
    B
    D
    C
    C
    E
    I want to load each value once into the target and the remaining values into another target. The data in the target tables are shown below:

    Code:
    Target1 : Contains value once
    ------
    A
    B
    C
    D
    E
    
    Target2: Remaining values
    -------
    B
    C
    C
    How to implement the mapping logic for this requirement in informatica.

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    The transformations in the mapping are:

    SRC->SQ->SORTER->EXPRESSION->ROUTER->TARGET

    Follow the below steps:

    1. Connect source qualifier transformation to the sorter transformation. Sort the data on the value column in ascending or descending order.
    2. Connect the sorter to expression transformation. create the below additional ports and assign the corresponding expressions:
    Code:
    v_current_value (variable port) = value
    v_count (variable_port) = IIF(v_current_value = v_previous_value, v_count+1,1)
    v_previous_value (variable port) = value
    o_count = v_count
    3. connect expression transformation to router transformation. Create one output group and specify the condition for the group as o_count = 1
    4. connect output group of router to one target and the default group to another target.

Similar Threads

  1. Unique Records in unix
    By Bandhavi in forum Unix
    Replies: 1
    Last Post: 09-10-2012, 06:54 AM
  2. Replies: 2
    Last Post: 07-18-2012, 08:37 AM
  3. Replies: 0
    Last Post: 07-17-2012, 08:34 AM
  4. Supress duplicate records - Informatica
    By vijay in forum Data Warehouse
    Replies: 1
    Last Post: 07-16-2012, 05:06 PM
  5. Replies: 1
    Last Post: 07-12-2012, 12:09 PM

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
  •