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 is grain of fact?
List few etl bugs?
what is different between sequential batch and concurrent batch and which is recommended and why?
what is the difference between cubes and package in cognos
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Can we create Hierarchies in generic datasources?
what is session partitioning?
what are the concerns of OLTP and DSS systems?
what are the concerns of OLTP and DSS systems?
Explain about etl data integration software?
can cubes contain measures ?
list and discuss two approaches for updation of target table in Informatica and how they are different.
What is tracing level?
What is tracing level? How many types of transformations supported by sorted input?
How many types of transformations supported by sorted input?