How to jion 2 tables, without using any condition?
- 11 Answers
- 34269 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 |
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
how to design mapping half of source table records into one target and remaining half into another target
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
who is the best faculty for informatica in hyderabad ameerpet?
8.what is mapplet ?give example?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
How to load the source table into flat file target(with columns) in informatica?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Can we update the data in flat file using update strategy?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
how do u fnd the duplicate rows and how to delete the duplicate rows?
Teradata 
