GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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 05:21:05 #3
 ricktesh   Member Since: Visitor    Total Comments: N/A 

RE: how to join the data of two tables which does not ...
 
in informatica we can't join two tables which does not have common port.

if there is any requirement then we go for source qualifier transformation,where we can use sql override on joining two tables which have no any common coulumn
     

 

Back To Question