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
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Different circumstance which drives informatica server to expel records?
what is index?how it can work in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Briefly define reusable transformation?
How many dimensions are there in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What does refresh system mean, and what are its distinctive choice?
What are the designer tools for creating transformations?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
what is degenerated dimension?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain in detail about scd type 1 through mapping.
What are different types of transformations available in informatica?