Interested to Buy Any Domain ? << Click Here >> for more details...
I have source like this 1:2;3. so i want to load the target
as 123
- 4 Answers
- 7478 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / dbseeker
Im don't think Replace function would work ..
We have replacechr and replacestr functions instead.
try this ..
REPLACESTR(1,'1:2;3',':',';','')
should work fine.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by a term domain?
what is size of u r database?
What are the uses of etl tools?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What will be the approach?
What are session parameters ? How do you set them?
Explain the etl program with few examples.
What are the modules in Power Center
What does cheating measurement mean?
How do you load first and last records into target table?
Describe expression transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is difference between a gateway node and worker node?
What are the different types of transformation available in informatica.
How do you convert single row from source into three rows into target?
