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
- 8685 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
What is union transformation?
Design time, run time. If you don't create parameter what will happen
How to create Target definition for flat files?
What is the format of informatica objects in a repository?
What is informatica etl tool?
How can one identify whether mapping is correct or not without connecting session?
What differs when we choose the sorted input for aggregator transformation?
How can we store previous session logs?
Explain what transformation and how many are there in informatica?
What is the fact table?
What are the different lookup cache(s)?
What is a connected transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what is the size of u r source(like file or table)?
What is xml source qualifier transformation in informatica?
