How to jion 2 tables, without using any condition?
- 11 Answers
- 34258 Views
- Amazon, I also Faced
- E-Mail Answers
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 |
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
What are the different options used to configure the sequential batches?
what is mapping parameter?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
explain different levels in pushdown optimization with example?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
How many repositories can we create in Informatica?
what is degenerated dimension
What is the difference between informatica 7.0 and 8.0?
what is the exact meaning of domain?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
Teradata 
