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

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

4 Answers  

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

What is incremental aggregation?

0 Answers  

8.what is mapplet ?give example?

2 Answers  

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

what is the look up transformation?

2 Answers   Informatica,

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

What is the session task and command task?

0 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

Explain what transformation and how many are there in informatica?

0 Answers  

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers