Data Warehousing and Data integration

Query on Joining Databases

TARUNTHAKUR
Topic Author
Offline
Junior Member

More

1 year 4 months ago #25045 by TARUNTHAKUR

Query on Joining Databases was created by TARUNTHAKUR

I wanted to discuss the possibility of connecting and joining queries from two databases in one program to get the final output based on the joint query. Alternatively, if there is another way to achieve this within a single program, I would appreciate your insights.

Code:

SELECT customer_name 
FROM OracleTable 
WHERE mobileno IN (SELECT mobileno FROM MSSQLTable);

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

admin
Offline
Administrator
Deeds not Words

More

1 year 4 months ago #25048 by admin

Replied by admin on topic Query on Joining Databases

There are multiple ways of doing it as usual.

In your case I think the best approach would be to use lookup transformation function

www.etl-tools.com/wiki/advanced-etl-proc...ions/lookups/lookup/

Please keep us posted on your progress

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

ETL Forum