| |
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 |
| June 06, 2007 11:03:03 |
#8 |
| Phani |
Member Since: Visitor Total Comments: N/A |
RE: how to join the data of two tables which does not ...
|
Create dummy column each in two table with same name and data type and assign default value as 1 for both after dragging the columns into SQ and/or Joiner Transformation(s) and use those columns in the join condition.
Hope this will work
All the best. |
| |
Back To Question | |
