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?
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
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the different clients of powercenter?
What is decode in informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain what are the different versions of informatica?
How can we delete duplicate rows from flat files?
What is the difference between STOP and ABORT options in Workflow Monitor?
How do you promote a non-reusable transformation to reusable transformation?
without table how to come first record only in oracle?
How do you load first and last records into target table?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What does cheating measurement mean?
How are indexes created after completing the load process?
server hot-ws270 is connect to Repository B. What does it mean?
How do you use reject loader.