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
- 8687 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
Explain transaction control transformation in informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
State the limitations where we cannot use joiner in the mapping pipeline?
What does “tail –f” command do and what is its use as an Informatica admin.
Under which circumstances, informatica server creates reject files?
what is size of u r database?
Separate from an archive server and a powerhouse?
Suppose we do not group by on any ports of the aggregator what will be the output?
Separate from a database, an information bazaar, and an information stockroom?
How to generate sequence numbers using expression transformation?
How to elaborate powercenter integration service?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain the difference between a data warehouse and a data mart?
How can we use mapping variables in informatica? Where do we use them?
