How will you display 10-15 letters from a name? (for ex:
name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

Answer Posted / krishna

by using thie function sbustr(column_name,10,15) in the exp
t/r, u can get the output.

Is This Answer Correct ?    21 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sessions in informatica etl?

619


What do you understand by a term domain?

673


How to create the source and target database connections in server manager?

634


What is joiner transformation in informatica?

629


Explain the tuning lookup transformation - informatica

615






How can we create index after completion of load process?

600


What are the databases that informatica can connect to windows?

587


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1844


Make a note of the quantity vaults made in informatica?

561


What is an expression transformation?

594


Mention a few design and development best practices for informatica?

563


How many dimensions are there in informatica?

632


Explain joiner transformation in informatica

672


How to call shell scripts from informatica?

578


What is domain in terms of informatica?

567