How will you display 10-15 letters from a name? (for ex:
name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
Answer Posted / bala
substr(col_name,10,5)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How does a sorter cache works?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How is union transformation utilized?
What is a predefined event?
what is the hint? how to use it to reduce the query processing in program?
What is a connected transformation?
Explain the types of lookup transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
When do you use sql override in a lookup transformation?
Differentiate between Load Manager and DTM?
Define sessions in informatica etl?
What does cheating measurement mean?
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
What is the difference between router and filter?
What are the conditions needed to improve the performance of informatica aggregator transformation?