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
- 5842 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 is an aggregator transformation?
How can you define user defied event?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the issues you have faced in your project? How did you overcome those issues?
What is a mapplet/worklet in informatica?
What is a joiner transformation?
What is the use of code page?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to create the source and target database connections in server manager?
State the differences between sql override and lookup override?
Explain load alternative records / rows into multiple targets - informatica
What are the advantages of informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
can we override a native sql query within informatica? Where do we do it?
