Skip navigation
Contact Us
1146 Views 2 Replies Latest reply: Dec 4, 2012 1:08 AM by Rajaraman R RSS
Kaushal Chauhan Newbie 1 posts since
Dec 3, 2012
Currently Being Moderated

Dec 3, 2012 11:37 PM

How to concatenate row data through informatica when 1 column contains Null value in source?

I have a source table like :

 

EmpNo

Name

100Sachin
NullTendulkar
101Rahul
NullDravid
102Saurav
Null

Ganguly

 

I want target table like this :

 

EmpNo

Name

100

Sachin Tendulkar
101Rahul Dravid
102Saurav Ganguly


i tried expression transformation but not able to load data in the target table. Can someone help to find the solution

  • Srinivasu Mamidi Newbie 3 posts since
    Dec 3, 2012

    In expression transformtation :

     

    Create an variable v_name and check this expression

    v_name=  IIF( NOT  ISNULL(Empno), name , v_name || name

     

    out_empno =  IIF(IS NULL (Empno) ,v_empno) ,  in_Empno

    out_name = v_name.

    out_flag  =  IIF(IS NULL (Empno) ,'Y','N')

     

    v_empno  = in_Empno.

     

    Router Transformation:

     

    use flag = 'Y' in the group.

     

    I think this will help you.

     

    ..Mamidi.

  • Rajaraman R Newbie 2 posts since
    Dec 4, 2012

    Algo. for your Scenario:

     

    Step-1:  Hold the Previous Record's ID (first Column date) in an Expression variable.

    Step-2:  When getting the Current Record, check for the NULL value in it. If, the current record has NULL Value for ID field, UPDATE the CURRENT RECORD value with PREVIOUS RECORD ID value. This also must happen in another EXPRESSION VARIABLE.

    Step-3:  Now, you are successfully holding ID value for all the records (By assigning its corresponding previous record's ID Value)

    Step-4: Current Dataset (flowing out of expression) is in NORMALIZED format.

    Step-5: This Dataset needs to be DENORMALIZED to get the required TARGET data. (This can be done in a traditional approach of EXPRESSION --> AGGREGATOR --> TARGET)

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points