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

Explain about enterprise scalability and roi of data integration suite?

0 Answers  


What are the key benefits of ETL Testing?

0 Answers  


how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com

2 Answers   TCS,


How to know informatica conslole password??

0 Answers  


What are cubes and olap cubes?

0 Answers  






what is a worklet?

0 Answers  


what is data modeling?

0 Answers  


Explain etl?

0 Answers  


What is meant by incremental load?

0 Answers  


A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  


What is the difference between Data Warehousing and Data Mining?

0 Answers  


Explain do we need an etl tool? When do we go for the tools in the market?

0 Answers  


Categories