select ‘(‘||substr(TNO,1,4)’)’||'

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.

Question Posted / rajesh

5 Answers
8467 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

Please Help Members By Posting Answers For Below Questions

What are the restrictions of union transformation?

976

permutations of mapplet

2450

Performance tuning( what you did in performance tuning)

1907

Enlist the differences between database and data warehouse.

1032

What could be the possible resons of locks by user?

1032

Whats there in global repository

1641

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1263

what is unit testing?tell me proceedure

2163

Explain the aggregator transformation?

1089

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1911

Under which circumstances, informatica server creates reject files?

1024

What is workflow monitor?

993

What is a pre-defined event and user-defined event?

970

expain about the tune parameters?

2334

How to call shell scripts from informatica?

933