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...


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

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

What are the differences between source qualifier and joiner transformation?

0 Answers  


hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,


How would you copy the content of one repository to another repository?

0 Answers  


What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  


we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  


&#61656; Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,


Explain what is informatica metadata and where is it stored?

0 Answers  


What is the maplet?

0 Answers   Informatica,


wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,


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

0 Answers  


Categories