You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » joining data from different DBs
Post a reply
Topic review (newest first)
- vital_parsley
- 2012-01-20 05:50:03
Fine thanks for the reply.
- saburo
- 2012-01-19 20:35:38
Hello
Yes you can.
The reason is that in ETL mode joins are not real joins (they are not performed on the DB).
However you cannot do that in ELT mode (i.e. with a tELTMap).
In tMap "joined" tables are basically lookups
- vital_parsley
- 2012-01-19 19:42:16
Hi,
A simple basic question
Can we join data coming from different DB sources using a tJoin or tMap ?
e.g
Data coming from Oracle ====
====tMap or tjoin or any joining component
Data coming from MSSQL====