Interested to Buy Any Domain ? << Click Here >> for more details...
I have source like this 1:2;3. so i want to load the target
as 123
- 4 Answers
- 7717 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
S.D--->S.Q....>EXP T/R......>TGT
In exp t/r create one out put port give condition
by using Replace function we can achieve this scenario.
or sql query :
select replace('1:2;3','1:2;3','123') from dual;
ans:
REP
---
123
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How can we use mapping variables in informatica?
What is the difference between a repository server and a powerhouse?
What is a shortcut and copy in Informatica and how two are different with each other?
can anyone suggest best free Talend data integration training online
what are 3 tech challenges/ common issues you face?
What is lookup transformation?
Which is the t/r that builts only single cache memory?
Can we create two repositories on same database instance in oracle?
How to update a particular record in target with out running whole workflow?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain what is informatica metadata and where is it stored?
how we can load rejected record's at run time?(not through bad files)
if we have a delimiters at unwanted places in a flat file how can we over come those.
How are indexes created after completing the load process?
Tell me about MD5 functions in informatica
