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
What is mapping debugger?
How many input parameters can exist in an unconnected lookup?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the difference between source qualifier transformations source filter to filter transformation?
Write the different tools in the workflow manager?
What are the features of complex mapping?
how to load rows into fact table in data warehouse
Enlist the advantages of informatica.
What is an expression transformation in informatica?
Which are the different editions of informatica powercenter that are available?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is informatica? Why do we need it?
What is union transformation in informatica?
Can we get 1st record through Informatica(without sequence number).
How do you update the records with or without using update strategy?