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 / mr lee
Select * From Table A Where ROWID = (Select Max(ROWID) From
Table A
Union
Select * From Table B Where Rownum = 1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Define update strategy?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain the shared cache and re-cache?
Quickly characterize reusable change?
Can we get 1st record through Informatica(without sequence number).
Explain the scenario which compels informatica server to reject files?
pmscmd startworkflow -sv
Enterprise data warehouse your projects phase by phase explain?
How to do unit testing in informatica?
Explain informatica architecture - version 8 / 9
What is the difference between informatica 7.0 and 8.0?
Under what condition selecting sorted input in aggregator may fail the session?
what is index?how it can work in informatica
Write the unconnected lookup syntax and how to return more than one column.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?