1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / dinesh

Answers were Sorted based on User's Feedback



follwing scenario two table using find maximum salary? table a table b 101..

Answer / 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

follwing scenario two table using find maximum salary? table a table b 101..

Answer / ankit kansal

Using Informaica

src-->>sq-->>rnk(sal,bottom,1)
-->>union-->>tgt
src-->>sq-->>rnk(sal,bottom,1)


http://deepinopensource.blogspot.in/

Is This Answer Correct ?    0 Yes 0 No

follwing scenario two table using find maximum salary? table a table b 101..

Answer / asdf

select id,name,max(sal) from table a;
select id,max(sal) from table b;

if u want to join two tables
select id,sal from table a,table b where a.id=b.id;

Is This Answer Correct ?    0 Yes 1 No

follwing scenario two table using find maximum salary? table a table b 101..

Answer / 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

follwing scenario two table using find maximum salary? table a table b 101..

Answer / murali udayagiri

select greatest(sub.emp_max_sal,sub.emp1_max_sal) from
(select (select max(sal) from emp) emp_max_sal,(select max
(sal) from emp1) emp1_max_sal from dual) sub;



Thanks,
Murali Udayagiri

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

What is joiner change?

0 Answers  

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

What is the use of code page?

0 Answers  

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,




Explain about HLD and LLD ?

16 Answers   Accenture,

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  

Why we use partitioning the session in informatica?

2 Answers  

what is distinct

4 Answers  

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories