Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / kumar

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

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

How can you recover the session in sequential batches?

1 Answers  

What is a code page?

0 Answers  

What is target update override

2 Answers   CTS,

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

Tell me about informatica architecture.

2 Answers   TCS,

how to insert header after each group.

1 Answers   IBM,

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

How to load last n records of file into target table - informatica

0 Answers   Informatica,

what is the size of ur database(like oracle)

2 Answers   HP,

what are presession,postsession success and postsession failure commands ?

1 Answers  

For more Informatica Interview Questions Click Here
Categories