my name is amar i want display 1st line A 2nd line M 3rd line
A 4th line R in database & informatica
- 1 Answers
- 3893 Views
- HCL, I also Faced
- E-Mail Answers
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 |
what is a test load?
what do u do when DB time takes more?in sap bi
when will use SQL override in a lookup transformation?
explain the methodology of Data Warehousing?(Polaries)
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
What is a lookup table in etl?
how do u decide whether u need to do aggregations at database level or at Informatica level?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What are the different Lookup methods used in Informatica?
what is session partitioning?
what is the difference between normal & bulk loading? and which one is recommended ? why?
Teradata 
