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
- 8482 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rajesh
select ‘(‘||substr(TNO,1,4)’)’||'_'||substr(TNO,5,3)||'_'||substr(TNO,8,3)) from TABLE_NAME
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What will be the approach?
What is meant by active and passive transformation?
What is an aggregator transformation?
How to extract sap data using informatica? What is abap? What are idocs?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain in detail about scd type 1 through mapping.
Under which circumstances, informatica server creates reject files?
How to handle decimal places while importing a flatfile into informatica?
What are the reusable transformations?
How many ways are there to create ports?
What are the features of complex mapping?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is the meaning of up gradation of repository?
How can repository reports be accessed without sql or other transformations?
COM components can be used in Informatica
