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
- 8638 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / manthiramoorthy. g
S==>SQ===>Exp===>Target
In Exp. Trans.
Create one port.
phone_out =
'('||SUBSTR(phno,1,3)||'-'||SUBSTR(phno,4,3)||'-'||SUBSTR(phno,7)
The Output is: (123)-456-7890
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
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?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How can we update a record in the target table without using update strategy?
What is incremental aggregation?
In development project what is the process to follow for an etl developer from day1
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is complex mapping?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is expression transformation?
How to update source definition?
What is the difference between Active and Passive transformation?
How many types of sessions are there in informatica.please explain them?
What is intricate mapping?
Explain load alternative records / rows into multiple targets - informatica
