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 meant by Normalization and de-normalization?

2 Answers  


Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  


can cubes contain measures ?

0 Answers  


what are the cubes developed in a sap bw project and what is the requirement for developing it?

0 Answers   Maersk,


how do u implement scheduling in Informatica?

1 Answers   Cognizant,






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

1 Answers   HCL,


what do u do when DB time takes more?in sap bi

0 Answers  


how do u implement configuration management in Informatica?

0 Answers  


What are the names of the layers in etl?

0 Answers  


What are materialized views & where do we use them?

0 Answers  


can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

0 Answers  


List few etl bugs?

0 Answers  


Categories