How will you display 10-15 letters from a name? (for ex: name="sivasubram&

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

Question Posted / kumar

4 Answers
8856 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'rama..

Answer / 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

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'rama..

Answer / bala

substr(col_name,10,5)

Is This Answer Correct ?

5 Yes

2 No

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'rama..

Answer / 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

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'rama..

Answer / usha

substrin (sivasubramaniamramakrishnan,11,5)

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More Informatica Interview Questions

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers IBM,

what are the transformations that restricts the partitioning of sessions?

1 Answers

When the informatica server marks that a batch is failed?

2 Answers

waht type of interface is used for testing the data in informatica

0 Answers CTS, TCS,

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers

How can we improve session performance in aggregator transformation?

0 Answers Informatica,

How you count the number of records available at your source?

3 Answers Zensar,

What is meant by active and passive transformation?

0 Answers

What is surrogate key?

9 Answers

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers TCS,

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers TCS,

For more Informatica Interview Questions Click Here