I have source like this 1:2;3. so i want to load the target
as 123
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 are the restrictions of union transformation?
Describe an informatica powercenter?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What's the layout of parameter file (what does a parameter file contain?)?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is meant by a domain?
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.
Whats there in global repository
Explain the different kinds of facts.
tell me about your project functionality
What is the procedure for creating independent data marts from informatica 7.1?
What is Cognos script editor?
What does update strategy mean, and what are the different option of it?