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
- 10629 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / pooja
CREATE TABLE B
AS
SELECT *
FROM
(SELECT *
FROM
(SELECT *,ROWNUM R
FROM A)
ORDER BY R DESC)
WHERE R=1;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is meant by active and passive transformation?
draw informatica architecture 8.6 ?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the scenario which compels informatica server to reject files?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the advantages of informatica?
What is meant by target load plan?
Can we get 1st record through Informatica(without sequence number).
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
waht type of interface is used for testing the data in informatica
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the reusable transformation?
What are active and passive transformations?
What is a node in Informatica?
