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
- 7359 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 to update or delete the rows in a target, which do not have key fields?
Define mapplet?
what is the hint? how to use it to reduce the query processing in program?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
what is the complex transformation you used in informatica
what is index?how it can work in informatica
Can we create multiple integration service on single repository?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain informatica architecture - version 8 / 9
What is the need of an ETL tool?
Which are the different editions of informatica powercenter that are available?
What are the reusable transformations?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to extract sap data using informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
