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 are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Identifying the bottlenecks in various components of Informatica and resolving them.
how do u set partition points in the mapping?
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.
what are the parts of Informatica server ?
What are the various tools used in etl?
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?
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
Is apache nifi an etl tool?
Hi, Lookup() is what kind of join ?