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 / shweta123
In the expression transformation use the following
function :
substr(name,1,(length(name) - instr(name,@,-1,1)))
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
Write the different tools in the workflow manager?
How to create the source and target database connections in server manager?
What is persistent lookup cache?
What are the differences between source qualifier and joiner transformation?
What is workflow? What are the components of workflow manager?
What is meant by target load plan?
How you prepared reports for OLAP?
Can anyone tell me the new features in Informatica 9 Version?
What is domain in terms of informatica?
How many input parameters can exist in an unconnected lookup?
What is the commit type if you have a transaction control transformation in the mapping?
What is a node in Informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
In warehouses how many schemas are there?