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 are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  


how do u set partition points in the mapping?

0 Answers  


Eliminating of duplicate records without using dynamic lookups

4 Answers   IBM,


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

2 Answers  






what are the parts of Informatica server ?

1 Answers   GE,


What are the various tools used in etl?

0 Answers  


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,


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  


Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

3 Answers   TCS,


Is apache nifi an etl tool?

0 Answers  


Hi, Lookup() is what kind of join ?

6 Answers   Satyam,


Categories