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
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What are your responsibilities as an etl tester?
what is data modeling?
What are the various tools used in etl?
what is the difference steps for data modeling?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Explain about etl data integration software?
What is partitioning? Explain about round-robin, hash partitioning.
When do we analyze the tables?
Give the benefits of data integration suite?
What is a staging area? What is the purpose of a staging area?
how do u handle performance issues in Informatica . where can u monitor the performance ?
what is Forward,Reverse and Re_engineering?
What is a lookup table in etl?
how would u estimate the size of Aggregator transform data and index cache?