SUBSTR(COLUMN_NAME,STARTING POSITION(10),NUMBER OF CHARACTER YOU WANT(5));

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

Question Posted / gyana

4 Answers
7297 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

Please Help Members By Posting Answers For Below Questions

What is an aggregator transformation?

617

generate date / time dimension in informatica

727

Can we create multiple integration service on single repository?

705

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4793

How many ways are there to create ports?

731

How to configure mapping in informatica?

682

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055

update strategy transformation in informatica

644

What is rank transformation?

583

What is union transformation in informatica?

701

What is blocking transformation?

724

Briefly define a session task?

595

What is the status code in stored procedure transformation?

689

What is meant by target load plan?

563

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

557