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
- 5 Answers
- 9054 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
Write the different tools in the workflow manager?
Explain in detail about scd type 1 through mapping.
What is a stored procedure transformation?
Write the prerequisite tasks to achieve the session partition?
How would you join a node to the already existing domain?
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 are the types of schemas we have in data warehouse.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
what is the hint? how to use it to reduce the query processing in program?
Please let me know how to make encryption and decryption with example?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What you know about transaction control transformation?
How to go to the older version for a mapping?
What the difference is between a database, a data warehouse and a data mart?
