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
- 8626 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ravi
i think the query should be like this
phoneno =
'('||SUBSTR(phno,1,3)||')'||'_'||SUBSTR(phno,4,4)||'_'||SUBSTR(phno,8,3)
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Describe data concatenation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to extract the informatica rejected data?
What is main use of mapplet?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is source qualifier transformation in informatica?
How many transformations can be used in mapplets.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is a sorter transformation?
Describe an informatica powercenter?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is parallel processing in informatica?
How can we improve session performance in aggregator transformation?
How many types of sessions are there in informatica.please explain them?
Explain the types of lookup transformation?
