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

What is the procedure to load the fact table.Give in detail?

1 Answers  

What is difference between maplet and reusable transformation?

2 Answers  

What does role playing dimension mean?

0 Answers  

How many repositories can be created in informatica?

1 Answers  

What is parallel processing in informatica?

0 Answers  

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

what is the difference between mapplet & stored procedure?

1 Answers  

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

what is left outer join?

3 Answers   L&T,

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

2 Answers  

For more Informatica Interview Questions Click Here
Categories