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

In how many ways we can create ports?

0 Answers  

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

what is curr val use for in sequence generator?

2 Answers   Emphasis,

Two different admin users created for repository are ______ and_______

1 Answers  

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,




Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

what is workflow varible

1 Answers   HP,

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

For more Informatica Interview Questions Click Here
Categories