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
- 9109 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
How do you handle two sessions in Informatica
can u any challenge your project?
What is sq transformation?
Write the prerequisite tasks to achieve the session partition?
Can you use flat files in Mapplets.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
COM components can be used in Informatica
Is it possible to define a single node as a Gateway node as well as worker node?
How can informatica be used for an organization?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the different transaction levels available in transaction control transformation?
How you can differentiate between connected lookup and unconnected lookup?
How do we call shell scripts from informatica?
Explain dynamic target flat file name generation in informatica
What is transformation?
