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


my name is amar i want display 1st line A 2nd line M 3rd line
A 4th line R in database & informatica



my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & infor..

Answer / lajpat kurdiya

SELECT SUBSTR('AMAR',LEVEL,1) AS Name
FROM DUAL
CONNECT BY LEVEL<= LENGTH('AMAR');

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More ETL Interview Questions

what is session partitioning?

0 Answers  


what are the concerns of OLTP and DSS systems?

0 Answers   TCS,


How to increase performance without changing anything in mapping.( In prod)

0 Answers   IBM, Saama Tech, Wipro,


Two default user groups created in the repository are____and_____.

0 Answers  


what are the parts of Informatica server ?

1 Answers   GE,


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  


How etl testing is different from database testing?

0 Answers  


What is cube grouping?

0 Answers  


what is pmrep command?

0 Answers  


list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 Answers  


what is session partitioning?

1 Answers  


What is etl tool in hadoop?

0 Answers  


Categories