Informatica - how to join the data of two tables which does not have common columns

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 147 of 298

how to join the data of two tables which does not have common columns

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

Total Answers and Comments: 10

Last Update: February 26, 2008 Asked by: cvgopal123

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 20, 2007 00:08:51

jaber

RE: how to join the data of two tables which does not ...

we can join two different tables which does'nt have common columns by using joiner transformation

Is this answer useful? Yes | No

March 21, 2007 11:14:37

vizaik

Member Since: March 2007 Contribution: 30

RE: how to join the data of two tables which does not ...

i think we can merge in SQ transformation

Is this answer useful? Yes | No

March 22, 2007 05:21:05

ricktesh

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

Is this answer useful? Yes | No

March 23, 2007 01:34:38

vizaik

Member Since: March 2007 Contribution: 30

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

Is this answer useful? Yes | No

March 25, 2007 19:13:46

rimmi

RE: how to join the data of two tables which does not ...

if the two tables do not have a common column but their data bases are same then you can use a Source Qualifier but if their data bases are different and u are trying to join the tables then its not possible to join in informatica.

Is this answer useful? Yes | No

March 27, 2007 02:16:44

Moin Ahmed

RE: how to join the data of two tables which does not ...

Plz if u send me the example query for the above comment title.

Is this answer useful? Yes | No

April 10, 2007 08:53:55

Dinesh.S

RE: how to join the data of two tables which does not ...

You can achieve the non-equal join result in informatica by using lookup transformation.

Is this answer useful? Yes | No

June 22, 2007 11:03:03

Phani

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.

Is this answer useful? Yes | No

February 19, 2008 04:12:42

komalahanumantharao

Member Since: November 2007 Contribution: 12

RE: how to join the data of two tables which does not have common columns

if both have the same structures we can join them using the union transformations
if i am wrong let me know it

Is this answer useful? Yes | No

February 26, 2008 13:27:47

#10

tanya123

Member Since: February 2008 Contribution: 17

RE: how to join the data of two tables which does not have common columns

Hi,

The best way to join data from two tables which donot have common columns is first use a sequence generator transformation to generate the keys,then connect it to an expression transformation and then use a joiner transformation to join the tables.I think this will work...

Any better answer will be appreciated...

Regards
Tanya

Is this answer useful? Yes | No

Go To Top