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")

Answer Posted / bala

substr(col_name,10,5)

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the commit type if you have a transaction control transformation in the mapping?

1030


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2075


what is the size of u r source(like file or table)?

2272


What is meant by target load plan?

974


I have a flat file, want to reverse the contents of the flat file

1127


What do you understand by SOA of Informatica?

989


Why do we need informatica?

992


Explain sessions?

1064


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2008


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167


How do you manage the Parameter files while migrating your data from one environment to another environment?

1018


What is a router transformation?

1129


Enlist some properties of sessions.

1068


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1901


How can we update a record in the target table without using update strategy?

1149