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
- 8845 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
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How does the aggregator transformation handle null values?
Define pmcmd command?
What is joiner transformation in informatica?
is it possible to index the data in cache of lkp transformation ?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is meant by a domain?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How can you increase the performance in joiner transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What does cheating measurement mean?
whats the logic to load the lower level of granularity of data to fact table.
What is the status code in stored procedure transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
