| |
GeekInterview.com > Tech FAQs > Informatica
| Print | |
Question: how to join the data of two tables which does not have common columns
Answer: how to join the data of two tables which do not have common column
i mean how to perform non equi join in informatica
Eg:just like getting data from emp and salgrade table of oracle where sal is between losal and hisal
thanks
venu |
| March 03, 2007 01:34:38 |
#4 |
| vizaik |
Member Since: March 2007 Total Comments: 27 |
RE: how to join the data of two tables which does not ...
|
i know how to join two tables in oracle,sql. i don't know about informatica
we can join two tables using exists command
for ex:
select ename from emp where exists (select * from dept where loc='DALLAS');
thank q |
| |
Back To Question | |
