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

Answer / ankit kansal

Using Informaica

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


http://deepinopensource.blogspot.in/

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;

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);

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

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

which transformation uses cache?

3 Answers   Keane India Ltd,

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

Differentiate between a repository server and a powerhouse?

0 Answers  

What is deployment group?

0 Answers  

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,