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
- 8920 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
Explain about Informatica server process that how it works relates to mapping variables?
Is it possible to create multiple domains on a single Informatica server?
what is the difference between informatica6.1 and infomatica7.1
what are factless facts? And in which scenario will you use such kinds of fact tables.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is rank index in rank transformation?
Write the advantages of partitioning a session?
What are the tuning techniques you applied during your last project
How to convert multiple rows to single row (multiple columns) in informatica
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How do you load alternate records into different tables through mapping flow?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
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
what is SDLC way of code development?
