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 three tier systems in etl?
Is apache nifi an etl tool?
what is the use of server manager?
how do u set partition points in the mapping?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What is a lookup table in etl?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
Explain about the data integration suite features?
What are the etl testing operations includes?
Difference between flat files and relational sources?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what is different between sequential batch and concurrent batch and which is recommended and why?
how to connect to a flatfile through ftp in informatica
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Explain do we need an etl tool? When do we go for the tools in the market?