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
- 10562 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
How to update source definition?
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.
What is the procedure for creating independent data marts from informatica 7.1?
What are the differences between a connected lookup and unconnected lookup?
Enlist the various types of transformations.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
difference between repository database and repository service?
How do you handle two sessions in Informatica
What are the components of workflow manager?
What are the types of lookup transformation?
What is meant by LDAP users?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Tell me about MD5 functions in informatica
What is the status code in stored procedure transformation?
