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
- 8926 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
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Plz can any one say me how to get the informatica certification materials and dumps
Which transformation is needed while using the Cobol sources as source definitions?
What is substr in informatica?
Explain in detail about scd type 1 through mapping.
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Design time, run time. If you don't create parameter what will happen
What is target designer and target load order?
How to use procedural logic inside infromatica?
What is union transformation in informatica?
How will the document be delivered to me?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
