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
- 7990 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 unconnected lookup syntax?
What is a dimensional model?
What are the different lookup cache(s)?
What is union transformation in informatica?
what is the size of u r source(like file or table)?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Where do we use mapping variables in informatica?
What is union transformation?
how to load dimension table and fact table. plz tell me the steps.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to load data in informatica ?
What is resilience time?
What is the different lookup cache(s)?
How do you promote a non-reusable transformation to reusable transformation?
Explain constraint based loading in informatica
