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 the main role of FI on business

0 Answers  


what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.

2 Answers   IBM, Tech Mahindra,


Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  


What is factless fact schema?

3 Answers  


how many maximum session supports to multiload in teradata ??

0 Answers   IBM,


what happens if the info.server doesn't find the session parameter in the parameter file?

1 Answers  


When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

0 Answers  


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

0 Answers  


In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

0 Answers  


what is the meaning of upgradation of Repository?

0 Answers   IBM,


what is meant by drill through?(Mascot)

1 Answers  


Explain and compare etl & manual development?

0 Answers  


Categories