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
What are dimensions?
what is the use of server manager?
What is virtual Data Warehousing?
what is Forward,Reverse and Re_engineering?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain about power designer data modeling software?
what is the difference between cardinality and Nullability?
What is a lookup table in etl?
What is cube grouping?
what is the use of server?
how do u set partition points in the mapping?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What is partitioning? Explain different types of partitioning?
What is a materialized view log?
what is the difference steps for data modeling?