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

Can you copy the session to a different folder or repository?

2 Answers

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers IBM,

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers IBM,

What are the types of presistent cache in look up tr.

0 Answers IBM,

What are the join types in joiner transformation?

1 Answers Informatica,

What are the types of groups in Router transformation?

1 Answers Informatica,

what is fact and what types of fact tables is there

4 Answers Cap Gemini,

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers

What is target load order?