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
- 5 Answers
- 7988 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 are the types of schemas we have in data warehouse and what are the difference between them?
Is it possible to create multiple domains on a single Informatica server?
What does reusable transformation mean?
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
Tell me about Propagate functions in informatica
Briefly describe lookup transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
expain about the tune parameters?
What is fact table? Explain the different kinds of facts.
What does update strategy mean, and what are the different option of it?
How does a rank transform differ from aggregator transform functions max and min?
can anyone suggest best free Talend data integration training online
Could you explain what is enterprise data warehouse?
What all join we can perform in LOOKUP transformation?
What is a passive transformation?
