Interested to Buy Any Domain ? << Click Here >> for more details...
follwing scenario two table using find maximum salary?
table a table b
101 xxx 1000 106 6500
103 yyy 5000 108 800
104 din 6000 109 7000
105 dsh 200 110 3000
- 5 Answers
- 9620 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gd
select max(sal) from table a,table b in (select
a.id,a.name,a.sal,b.id.b.sal from table a, tableb where
a.id=b.id);
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is Data Caches size?
What are the tasks that can be performed using sq?
Briefly explain the aggregator transformation?
Differentiate between router and filter transformation?
Explain lookup transformation in informatica
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How to improve the performance of a session using sorter transformation?
What is DR strategy for Informatica project?
What is workflow manager?
What is a standalone command task?
How does the aggregator transformation handle null values?
Can we get 1st record through Informatica(without sequence number).
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain sessions?
