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
Answer Posted / dinesh
select max(sal) from (select max(sal) as sal from table a)
union
(select max(sal) as sal from table b)
ans:
sal
7000
6000
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How do you load alternate records into different tables through mapping flow?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to create Target definition for flat files?
How to extract sap data using informatica? What is abap? What are idocs?
What are data-driven sessions?
How to create a non-reusable instance of reusable transformations?
expain about the tune parameters?
Is it possible to revert a global repository to local one and why?
Explain lookup transformation in informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Why union transformation is an active transformation?
What is the function of look up transformation?
What is lookup change?
update strategy transformation in informatica