I have source like this 1:2;3. so i want to load the target as 123

I have source like this 1:2;3. so i want to load the target
as 123

Question Posted / santhosh

4 Answers
6230 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have source like this 1:2;3. so i want to load the target as 123..

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

I have source like this 1:2;3. so i want to load the target as 123..

Answer / soujanya

select replace('1:2;3','1:2;3','123') from dual;

Is This Answer Correct ?

1 Yes

0 No

I have source like this 1:2;3. so i want to load the target as 123..

Answer / dbseeker

Im don't think Replace function would work ..
We have replacechr and replacestr functions instead.
try this ..

REPLACESTR(1,'1:2;3',':',';','')

should work fine.

Is This Answer Correct ?

0 Yes

0 No

I have source like this 1:2;3. so i want to load the target as 123..

Answer / dilip ingole

using sql same thing in informatica also

SELECT REGEXP_REPLACE('1:2;3.','[^[:digit:]]','') DATA FROM DUAL;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers Informatica,

What is the need of building a data warehouse?

2 Answers

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers IBM,

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers Hexaware,

what are the perameter and variable?

3 Answers IBM,

what is the difference between copy object import objects using repositery manager which one is best

1 Answers TCS,

What are partitions in informatica and which one is used for better performance?

2 Answers

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers CTS,

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers TCS,

How do you create single lookup transformation using multiple tables?

6 Answers TCS,

Which version configuration tool used in ur project?

0 Answers CTS, TCS,

list out all the transformations which use cache?

0 Answers Informatica,

For more Informatica Interview Questions Click Here