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 data movement mode in Informatica and difference between them?

0 Answers  

What is difference between maplet and reusable transformation?

2 Answers  

What are the types of caches in lookup? Explain them.

0 Answers  

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

Differentiate between a database and data warehouse?

0 Answers  




1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories