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
- 8747 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
Separate from a database, an information bazaar, and an information stockroom?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain your project of banking domian.
How many types of sessions are there in informatica.please explain them?
What is the need of etl tools?
Briefly describe lookup transformation?
What are the settings that you use to configure the joiner transformation?
What is Cognos script editor?
What is the need of an ETL tool?
Why update strategy and union transformations are active? Explain with examples.
Explain the difference between mapping parameter and mapping variable?
Explain the difference between a data warehouse and a data mart?
What are the advantages of using informatica as an etl tool over teradata?
How to start a workflow using pmcmd command?
Differences between connected and unconnected lookup?
