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
- 10558 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
Different circumstance which drives informatica server to expel records?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Differences between connected and unconnected lookup?
What is Cognos script editor?
What the difference is between a database, a data warehouse and a data mart?
As union transformation gives UNION ALL output, how you will get the UNION output?
explain one complex mapping with logic? sales project?
EXL informatica Questions
Define update strategy?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is joiner transformation 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?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is Index Caches size?
