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
- 9667 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 are the differences between joiner transformation and source qualifier transformation?
What are the different options available for update strategy?
What is the scenario which compels informatica server to reject files?
What are the limitations of joiner transformation?
Whats there in global repository
How to use procedural logic inside infromatica?
What are session parameters ? How do you set them?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Which means the first record should come as last record and last record should come as first record and load into the target file?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
can we override a native sql query within informatica? Where do we do it? How do we do it?
What do you mean incremental aggregation?
What is joiner change?
State the limitations where we cannot use joiner in the mapping pipeline?
Difference between Data and Index Caches?
