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
- 5721 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
Is there any way to read the ms excel datas directly into informatica?
What is the command used to run a batch?
What are the main features of Oracle 8i with context to datawarehouse?
How do you load first and last records into target table?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain transaction control transformation in informatica
How to update a particular record in target with out running whole workflow?
What do you understand by a term domain?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
differences between service based and product based?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain the difference between a data warehouse and a data mart?
Can u generate reports in Informatica?
What are the guidelines to be followed while using union transformation?
