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
- 10893 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
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Differentiate between sessions and batches?
Did u used latest transformations of 8.6.0? for what?
how tokens will generate?
How to create Target definition for flat files?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Global and Local shortcuts. Advantages.
what is the size of your data warehousing?
What is the use of source qualifier?
How to delete duplicate row using informatica?
Repository user profiles
Why update strategy and union transformations are active?
What are the measure objects?
What are the popular informatica products?
