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
7360 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 is the difference between informatica 7.0 and 8.0?

0 Answers

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers Magna Infotech,

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers Infosys,

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers

Which is better performance wise database or file?How?

2 Answers TCS,

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers iNautix,

How many numbers of sessions can one group in batches?

0 Answers

When do you use sql override in a lookup transformation?

0 Answers

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers HCL,

What are connected or unconnected transformations?

0 Answers Informatica,

When to use normalization transformation other than cobol source?

2 Answers

For more Informatica Interview Questions Click Here