my name is amar i want display 1st line A 2nd line M 3rd line
A 4th line R in database & informatica
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 the difference steps for data modeling?
what is an ETL or ETT? And what are the different types?
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
what are business components in Informatica?
What is Relational Integrity?
What are the types of Data Warehouse applications?
How can we use external procedural logic in informatica?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
Eliminating of duplicate records without using dynamic lookups
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what is pmrep command?