Answer / jaimeen shah

it is not possible to actually join two tables without
using any condition.
if U would like to join two tables, then in source
qualifier transformation add all the port from two tables (
if both tables are from same database source) and write
down your join condition in user defined join option or
otherwise write down join condition inside the sql query
option with generated sql query.

if u use two different database source then use joiner to
join the two tables.

Answer / kalyan

In SQL override (Source Qualifier level) write a query to
join the 2 tables like emp & dept as follows:

Select * from emp,dept;

The above query will return the cartesian product of the 2
tables; BTW, this don't have any condition...

Answer / raj

Add dummy column in expression or Source Qul. for both
source and use that column in join condition.

Answer / bittu sarkar

simply use a dummy condition like 1=1.
This works :)

Answer / rajesh

select * from emp natural join dept;

Answer / balu024

use union transformation, if two tables having same meta data

Answer / chetan sharma

use natural join.

it automatically takes column from the both of table that are equal via column name and their datatype.
example:> two table employee,department and one field is
common b/w these two table and this is dept_no then
"select * from employee natural join department" will automatically retrieve the those rows from the both table that have the same dept_no.........

Answer / manjula

it is not possible to actually join two tables without
using any condition.
if U would like to join two tables, then in source
qualifier transformation add all the port from two tables (
if both tables are from same database source) and write
down your join condition in user defined join option or
otherwise write down join condition inside the sql query
option with generated sql query.

if u use two different database source then use joiner to
join the two tables

Answer / suman

Instead of Join use subquery

Answer / asif

can anybody explain me how to join two tables without using
joins with example....

what is diff between grep and find

3 Answers   IBM, iFlex,

What is the status code in stored procedure transformation?

0 Answers   Informatica,

What are two types of processes that informatica runs the session?

2 Answers  

in which situations do u go for sequence generator ?

2 Answers   TCS,

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

what is metadata?

6 Answers  

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

Explain the use of aggregator cache file?

0 Answers  

What is informatica etl tool?

0 Answers  

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

What is Index Caches size?

0 Answers   Informatica,

Define sessions in informatica etl?

0 Answers