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?
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
How to delete duplicate row using informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is dynamic cache?
How many ways are there to create ports?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is workflow manager?
What is the use of transformation?
How to update or delete the rows in a target, which do not have key fields?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Explain the different dimensions.
Explain the mapping variable usage example in informatica
Explain the difference between mapping parameter and mapping variable?
What is aggregator transformation in informatica?
While migrating the data from one environment to another environment how would you manage the connections?
Write the different tools in the workflow manager?