Interested to Buy Any Domain ? << Click Here >> for more details...
i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc
- 3 Answers
- 5678 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / vidhyakarthik
SQ - Exp - Target
In exp transformation
newport1 - SUBSTR(column1,1,3)
newport2 - LTRIM(RTRIM(column1))
newport3 - REPLACECHR(1,newport2,'101','')
newport4 - newport1 || ' ' || newport3
pass newport4 to target
anyone pls confirm if it is wrong
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the types of caches in lookup? Explain them.
What is an Integration service in Informatica?
What do you mean by channel change?
What is Cognos script editor?
Explain how to import oracle sequence into informatica?
What is primary and backup node?
What are pre and post-session shell commands?
What differs when we choose the sorted input for aggregator transformation?
What is the sql query overwrite in source qualifier in informatica
How you can differentiate between connected lookup and unconnected lookup?
How would you join a node to the already existing domain?
What are multi-group transformations?
What are the new features of informatica 9.x at the developer level?
Explain Dataware house architecture .how data flow from intial to end?
What is the benefit of session partitioning?
