Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

Why filter transformation is an active one?

0 Answers  

What is meant by a domain?

0 Answers  

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

What are the new features of informatica 9.x in developer level?

0 Answers  

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

What is informatica? What exactly are the practical uses in real world

2 Answers  

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

For more Informatica Interview Questions Click Here
Categories