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
- 11085 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / devi
CREATE TABLE B
AS
SELECT * FROM A
ORDER BY ROWNUM DESC;
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
Explain in detail about scd type 1 through mapping.
What are junk dimensions?
What is meant by lookup transformation? Explain the types of lookup transformation?
What are the performance considerations when working with aggregator transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
Separate from an archive server and a powerhouse?
What are the differences between joiner transformation and source qualifier transformation?
Explain incremental aggregation in informatica
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How can we use mapping variables in informatica? Where do we use them?
What is a node in Informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
COM components can be used in Informatica
What is the difference between router and filter?
How to use pmcmd utility command?
