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 / babu
Hi Sbvprasad,
Your answer has small correction,
V1=iif(not isnull (id),id,v1)
for the 1st record.
V1= iif( not isnull (101), then pass 101).
now the V1 variable having the value = 101.
2nd record
V1= iif( not isnull ( null), then pass else condition V1 (
having 101 ))
now the V1 variable having the value = 101.
3rd record
V1= iif( not isnull ( null), then pass else condition V1 (
having 101 ))
now the V1 variable having the value = 101.
After applied the above logic we will get the output as
mentioned below.
-------------
ID NAME
--- ------
101 PANKAJ
101 KUMAR
101 MATHUR
102 JYOTI
102 SAXENA
103 SACHIN
102 TENDULKAR
2.Take an EXP t/r,in this t/r declare two variable ports
for ID and Name columns.those are PRV_ID and VAR_NAME
VAR_NAME=IIF(PRV_ID=ID,VAR_NAME||' '||NAME,NAME)
PRV_ID=ID
OP_NAME=VAR_NAME (OUTPUT PORT)
3.In the next step take the aggregator transformation and
group by on the ID COLUMN. Then you will get the result.
TARGET TABLE
-------------
ID NAME
--- -------
101 PANKAJ KUMAR MATHUR
102 JYOTI SAXENA
103 SACHIN TENDULKAR
MAPPING ::
---------
SRC-->SQ-->EXP-->EXP-->AGGR-->TRG
IF ANY THING WRONG, PLEASE CORRECT WITH PROPER SOLUTION.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are multi-group transformations?
What is InformaticaPowerCenter?
What are the types of caches in lookup? Explain them.
While migrating the data from one environment to another environment how would you manage the connections?
permutations of mapplet
How do you convert single row from source into three rows into target?
What is rank transform?
What is sequence generator transformation in informatica?
How can you validate all mappings in the repository simultaneously?
can anyone suggest best free Talend data integration training online
What are the features of complex mapping?
What are the tasks that can be performed using sq?
Does an informatica transformation support only aggregate expressions?
What are active transformations.
What is rank index in rank transformation?