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

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3401


What are your responsibilities as an etl tester?

721


what is data modeling?

1549


What are the various tools used in etl?

639


what is the difference steps for data modeling?

1661






Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1650


Explain about etl data integration software?

573


What is partitioning? Explain about round-robin, hash partitioning.

636


When do we analyze the tables?

623


Give the benefits of data integration suite?

581


What is a staging area? What is the purpose of a staging area?

576


how do u handle performance issues in Informatica . where can u monitor the performance ?

4355


what is Forward,Reverse and Re_engineering?

1804


What is a lookup table in etl?

697


how would u estimate the size of Aggregator transform data and index cache?

1620