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 / sbvprasad
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.In the next step take the aggregator transformation and
group by on the id. Then you will get the result.
TARGET TABLE
-------------
ID NAME
--- -------
101 PANKAJ KUMAR MATHUR
102 JYOTI SAXENA
103 SACHIN TENDULKAR
Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
What is meant by target load plan?
What is a sorter transformation?
Mention a few design and development best practices for informatica?
What is joiner transformation?
What are ETL Tools?
Explain the mapping variable usage example in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
What is the use of target designer?
What is the use of an aggregator cache file?
Please let me know how to make Data masking in informatica..
Define the various join types of joiner transformation?
What are the differences between source qualifier and joiner transformation?
What is deployment group?
Differences between connected and unconnected lookup?
What is the way to execute pl/sql script using informatica mapping?