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

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

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

0 Answers   Informatica,




how will you remove the duplicate records from flat file without using sorter?

7 Answers  

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

What are the out put files that the informatica server creates during the session running?

2 Answers  

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

Did u used latest transformations of 8.6.0? for what?

0 Answers  

For more Informatica Interview Questions Click Here
Categories