Interested to Buy Any Domain ? << Click Here >> for more details...
Total Questions Posted # 0
Total Answers Posted # 1
Total Answers Posted for My Questions # 0
Total Views for My Questions # 0
Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0
Total Answers Posted # 1
Total Answers Posted for My Questions # 0
Total Views for My Questions # 0
Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0
Questions / { narayana swami }
Questions
Answers
Category
Views
Company
eMail
Answers / { narayana swami }
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
Answer
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 |
