Interested to Buy Any Domain ? << Click Here >> for more details...
my source contain data like this
eno ename phno
100 john 9989020508
101 ram 7246599999
i want to load the data into target is
eno name phno
100 john (998)-9020-508
102 ram (724)-6599-999.
- 5 Answers
- 8480 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / manthiramoorthy. g
S==>SQ===>Exp===>Target
In Exp. Trans.
Create one port.
phone_out =
'('||SUBSTR(phno,1,3)||'-'||SUBSTR(phno,4,3)||'-'||SUBSTR(phno,7)
The Output is: (123)-456-7890
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
Which development components of informatica have the highest usage?
Under which circumstances, informatica server creates reject files?
What is the difference between source qualifier transformations source filter to filter transformation?
What are junk dimensions?
What is domain and gateway node?
What are the settings that you use to configure the joiner transformation?
How do you convert single row from source into three rows into target?
What all are steps in up gradation of Informatica server?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
how tokens will generate?
How might one distinguish in the case of mapping is right or not without associating session?
What is the difference between router and filter?
Explain the code page compatibility?
What is a router transformation?
How union transformation is used?
