How to jion 2 tables, without using any condition?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 24 Yes | 4 No |
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...
Is This Answer Correct ? | 16 Yes | 2 No |
Answer / raj
Add dummy column in expression or Source Qul. for both
source and use that column in join condition.
Is This Answer Correct ? | 12 Yes | 4 No |
Answer / bittu sarkar
simply use a dummy condition like 1=1.
This works :)
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / balu024
use union transformation, if two tables having same meta data
Is This Answer Correct ? | 4 Yes | 2 No |
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.........
Is This Answer Correct ? | 2 Yes | 0 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
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / asif
can anybody explain me how to join two tables without using
joins with example....
Is This Answer Correct ? | 1 Yes | 1 No |
How to start a workflow using pmcmd command?
How to configure mapping in informatica?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
What is the query to find nth highest salary? What is the use of cursors?
What are the types of schemas we have in data warehouse.
What is A cache?
how can you load data into target table without leading zeor's
how to duplicates from expression transformation without using sorter before that
What are the main issues while working with flat files as source and as targets ?
what is worklet and what use of worklet and in which situation we can use it?