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


Please Help Members By Posting Answers For Below Questions

How will the document be delivered to me?

621


Explain the difference between a data warehouse and a data mart?

600


Explain joiner transformation in informatica

670


What is difference between a gateway node and worker node?

630


Where can we find the throughput option in informatica?

600






Write the unconnected lookup syntax?

662


Differences between version 7.x and 8.x.

1419


Explain how to import oracle sequence into informatica?

594


waht type of interface is used for testing the data in informatica

1835


Parameter and variable differences

1618


What is Cognos script editor?

3788


Why is sorter an active transformation?

667


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1649


What is an Integration service in Informatica?

705


Different sorts of metadata that stores in the storage facility?

563