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
what is the Default Source Option For Update Strategy Transformation?
Under what condition selecting sorted input in aggregator may fail the session?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How do you load only null records into target? Explain through mapping flow.
Explain lookup transformation in informatica
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 ?
What is mapping debugger?
How to elaborate tracing level?
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
Partition, what happens if the specified key range is shorter and longer
What are the different ways to implement parallel processing in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com