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
- 8854 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
Did u used latest transformations of 8.6.0? for what?
Separate from an archive server and a powerhouse?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is a node in Informatica?
What are active transformations.
Have you worked with/created Parameter file
explain abt ur project architecture?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the modules in Power Center
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Enterprise data warehouse your projects phase by phase explain?
Can we get 1st record through Informatica(without sequence number).
What are the types of data warehouses?
what is size of u r database?
in reporting we add some new objects,how we get the count of the newly added objects to the report
