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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

2791


Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

1993


explain the methodology of Data Warehousing?(Polaries)

1995


Explain etl?

736


Explain do we need an etl tool?

709


How to fine tune mappings?

726


how do u identify the changed records in operational data?

2299


What are the etl testing operations includes?

802


tell me few points when u become TL

2210


What is etl process? How many steps etl contains?

780


How many types of transformations supported by sorted input?

895


Explain what is etl process? How many steps etl contains explain with example?

672


How can we use external procedural logic in informatica?

716


What is abap? What are idocs?

689


Explain etl mapping sheets?

840