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
- 8484 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ravikumar2614
phone_no=||'('||substr(pno,1,3)||')-'||substr(pno,4,3)||'-'||substr(pno,8,3)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to elaborate powercenter integration service?
In which transformation you cannot drag ports into it?
How to update or delete the rows in a target, which do not have key fields?
Explain load alternative records / rows into multiple targets - informatica
How can you define user defied event?
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?
How can we use batches?
What do you mean by enterprise data warehousing?
What are the tasks that source qualifier perform?
Different circumstance which drives informatica server to expel records?
What is workflow monitor?
How we can use union transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
