Source table
-------------
ID NAME
--- ------
101 PANKAJ
NULL KUMAR
NULL MATHUR
102 JYOTI
NULL SAXENA
103 SACHIN
NULL TENDULKAR
TARGET TABLE
-------------
ID NAME
--- -------
101 PANKAJ KUMAR MATHUR
102 JYOTI SAXENA
103 SACHIN TENDULKAR
How to do the above scenario in Informatica.
Answer Posted / nagraj
From SQ pass to Expression Transformation
- Take Variable for ID i.e.
V_ID =iif(not isnull(ID),ID ,V_ID )
- Take Variable for Name i.e.
iif( isnull(ID) ,CONCAT(CONCAT(LTRIM(RTRIM
(V_old_Name)),' ') ,Name),Name)
At this stage you will see the Data like this
ID Name
101 PANKAJ
101 PANKAL KUMAR
101 PANKAJ KUMAR MATHUR
Now pass the ID and NAME output port through an Aggregator
Transformation
-Take new variable for Name i.e.
New_Name=concat(concat(New_Name,' '),Name)
-Take new output port for Name and put expression for the
Name output port as follows
Out_Name=GREATEST(Name,New_Name)
- Check Group By on ID
Pass the ID and Name outpurt port to the Target.
option (truncate and load)
Where Group by on ID port
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is union transformation?
What are the components of workflow manager?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How many types of sessions are there in informatica.please explain them?
What is the procedure for creating independent data marts from informatica 7.1?
Define filter transformation?
What is main use of mapplet?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How to start a workflow using pmcmd command?
What is informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What do you mean by blocking transformation?
What are the data movement modes in informatica?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?