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
IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
Answers were Sorted based on User's Feedback
Answer / keshav
CREATE AN EXPRESION TALE 2 VARIABLE AND 2 OUTPUT PORTS
FOR VARIABLE PORTS WRITE THE BELOW EXPRESSIONS
V_NAME(v)=IIF((IIF(ISNULL(ID),V_ID,ID)=V_ID),V_NAME || ' ' || NAME,NAME )
V_ID(v)=IIF(ISNULL(ID ) , V_ID, ID )
OUT_ID(o)=V_ID
OUT_NAME(o)=V_NAME
AFTER TAKE AGGREGATER AND SELECT OUT_ID AS GROUP BY PORT
AFTER CONNECT TO TARGET
Is This Answer Correct ? | 4 Yes | 1 No |
HI FRIENDS........
Please check this answer....
source table has 2 columns id,name.pass to expression .
remove o/p port in name column,take another port select only o/p port, write code in side of the port
REPLACECHR(0,NAME,'NULL',' ')
pass to target. mapping like
SD=>SQ=>EXP=>TGT.
Is This Answer Correct ? | 0 Yes | 0 No |
8.what is mapplet ?give example?
Did u used latest transformations of 8.6.0? for what?
what is the diff b/w target load plan and cbl?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
What are the different clients of powercenter?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
How we can create indexes after completing the loan process?
what are the limitations of pushdown optimization technique ? Advance thanks
what are objects in data warehouse?
What are the advantages of using informatica as an etl tool over teradata?