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
- 8625 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
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is rank transformation?
What is domain in terms of informatica?
Enterprise data warehouse your projects phase by phase explain?
When do you use sql override in a lookup transformation?
Briefly define reusable transformation?
Informatica settings are available in which file?
can anyone suggest best free Talend data integration training online
What does cheating measurement mean?
How can we delete duplicate rows from flat files?
Explain about cumulative Sum or moving sum?
What is informatica metadata and where is it stored?
