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
- 8846 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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What could be the possible resons of locks by user?
How many numbers of sessions can one group in batches?
What is lookup transformation?
What are the new features of Power Center 5.0?
r u done any partitions in ur project?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain lookup transformation source types in informatica
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is deployment group?
Explain what is informatica metadata and where is it stored?
What are the different components of powercenter?
Explain in detail about scd type 1 through mapping.
What is a sequence generator transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
