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

my source contain data like this
cno cname sal
100 rama@gmail.com 1000
200 karuna@yahoo.com 2000
i want load my data to the target is
cno cname sal
100 rama 1000
200 karuna 2000
plz send the answer

Answer Posted / sehaj

DO ONE THING....
CREATE AN EXTRA PORT FOR THAT.
IN THE EXPRESSION EDITOR,WRITE

REPLACESTR(0,cname,(SUBSTR(cname,INSTR(cname,'@'),INSTR(cname,'m',-1,1)),'')

PASS THIS PORT TO THE OUTPUT PORT......


SEHAJ-7204719446

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the Default Source Option For Update Strategy Transformation?

1241


Under what condition selecting sorted input in aggregator may fail the session?

1127


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2060


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2305


How do you load only null records into target? Explain through mapping flow.

2028


Explain lookup transformation in informatica

1073


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2365


What is mapping debugger?

1017


How to elaborate tracing level?

1179


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1963


Partition, what happens if the specified key range is shorter and longer

2499


What are the different ways to implement parallel processing in informatica?

1423


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7066


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1079


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1921