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
- 10891 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / upendra
select * from (select rownum as num,a.* from A a) where num=(select count(*) from A);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How will the document be delivered to me?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Where is metadata stored?
Why do you use Mapping Parameter and mapping variable?
What are the reusable transformations?
What are Dimensional table?
How to differentiate between the active and passive transformations?
What are mapplets?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is dynamic cache?
What are the modules in Power Center
If informatica has its scheduler why using third party scheduler?
What is the difference between a repository server and a powerhouse?
What is the difference between stop and abort in informatica
