1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / santhosh

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..

Answer / 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

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 joiner transformation?

0 Answers  

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,




What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

which one is better either active or passive transformation in informatica

1 Answers  

why u go for dimensions ?

3 Answers   TCS,

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

What does refresh system mean, and what are its distinctive choice?

0 Answers  

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

For more Informatica Interview Questions Click Here
Categories