Interested to Buy Any Domain ? << Click Here >> for more details...
How will you display 10-15 letters from a name? (for ex:
name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
- 4 Answers
- 9038 Views
- I also Faced
- E-Mail Answers
Answer Posted / gyana
SUBSTR(COLUMN_NAME,STARTING POSITION(10),NUMBER OF CHARACTER YOU WANT(5));
IT WILL GIVE YOU THE OUT PUT 10TH POSITION TO 15 TH CHARACTER STRING
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the Methods For Creating Reusable Transformations?
In warehouses how many schemas are there?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How can we remove the duplicates from flat file source?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Define mapplet?
Explain the features of connected and unconnected lookup.
How can we delete duplicate rows from flat files?
Which files are created during the session rums by informatics server?
What is powercenter on grid?
What is a standalone command task?
what is the hint? how to use it to reduce the query processing in program?
How to create or import flat file definition in to the warehouse designer?
Briefly describe lookup transformation?
