Interested to Buy Any Domain ? << Click Here >> for more details...
i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?
- 7 Answers
- 11101 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / dilip ingole
by using with clause
WITH DATA AS(SELECT NUM,ROWNUM RN ,COUNT(1)OVER() CNT FROM A)
SELECT NUM,RN FROM DATA WHERE RN=1
UNION
SELECT NUM,RN FROM DATA WHERE RN=CNT;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of code page?
What is substr in informatica?
What is a passive transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Clarify the utilization of aggregator cache record?
Define the various join types of joiner transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain what are the different types of transformation available in informatica.
What is an unconnected transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is an aggregator transformation?
What is a transaction control transformation?
Do you find any difficulty while working with flat files as source and target?
What is meant by incremental aggregation?
What does role playing dimension mean?
