How can we join the tables if they don't have primary and foreign key rel

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

How can we join the tables if they don't have primary and
foreign key relationship and no matching port?

Question Posted / guest

7 Answers
15714 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we join the tables if they don't have primary and foreign key relationship and no mat..

Answer / kishore

Very Simple guys....

Do a Override in SQ:

Select * from Tab1, Tab2

Is This Answer Correct ?

4 Yes

1 No

How can we join the tables if they don't have primary and foreign key relationship and no mat..

Answer / lokesh

Manually add dummy cols to both table with same data type and join dem with joiner transformation

Is This Answer Correct ?

1 Yes

0 No

How can we join the tables if they don't have primary and foreign key relationship and no mat..

Answer / kalyan

Option 1:

Drag both the sources to an expression. Hardcord a new
field say NEW_VALUE=1, in both the expressions.
Now join both these pipelines using the joiner with join
condition on the new_field you havecreated(NEW VALUE)

Option 2:

How abt using a full outer join as the type of join in the
joiner Transformation...

Is This Answer Correct ?

3 Yes

3 No

How can we join the tables if they don't have primary and foreign key relationship and no mat..

Answer / niroshreddy@gmail.com

hello hero's dont send wrong answers ..................

Is This Answer Correct ?

0 Yes

0 No

How can we join the tables if they don't have primary and foreign key relationship and no mat..

Answer / ramz

use Cartesian product or cross join
select required columns from tab1,tab2;

Is This Answer Correct ?

0 Yes

0 No

How can we join the tables if they don't have primary and foreign key relationship and no mat..

Answer / developer

use a union transformation if there are no matching ports.

Is This Answer Correct ?

0 Yes

5 No

How can we join the tables if they don't have primary and foreign key relationship and no mat..

Answer / veera reddy

Using joiner transformation.

Is This Answer Correct ?

2 Yes

10 No

Post New Answer