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

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

What is domain in terms of informatica?

0 Answers  




source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

From where we can start or use pmcmd?

3 Answers  

when we dont use aggregator in mapping ?

2 Answers   CSC,

Explain scd type 3 through mapping.

0 Answers  

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

What is a sequence generator transformation?

0 Answers  

In a sequential batch can you run the session if previous session fails?

4 Answers  

For more Informatica Interview Questions Click Here
Categories