Informatica [message #147792] |
Mon, 21 November 2005 01:39 |
renukha
Messages: 7 Registered: November 2005 Location: Bangalore
|
Junior Member |
|
|
Hi,
Can any one tell me how to join two tables without using Source Qualifier and Joiner Transformation in Informatica?
|
|
|
Re: Informatica [message #147825 is a reply to message #147792] |
Mon, 21 November 2005 05:09 |
kiran
Messages: 503 Registered: July 2000
|
Senior Member |
|
|
Quote: | Can any one tell me how to join two tables without using Source Qualifier and Joiner Transformation in Informatica?
|
Are you preparing for some interview?
As per my knowledge,
Informatica has Joiner transformation as it Enables us to join data which is originating from different source.For example we can join the data from two different relational tables which are residing in same database.The joiner specific purpose is for joining tables.or else , we can write a join query while defining the source and can join the tables.
These are two ways that i know for joining tables.If you find any other way , feel free to post it here.
--Kiran.
|
|
|