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 are the data movement modes in informatcia?

1 Answers  

Can a joiner be used in a mapplet.

1 Answers  

What did you do in source pre load stored procedure

1 Answers  

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

what is the incremental agrrigation?

2 Answers   Cap Gemini,

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

How to do unit testing in informatica?

0 Answers  

explain different types of modeling.

2 Answers  

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

how to insert header after each group.

1 Answers   IBM,

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,