Home » Fusion Middleware & Colab Suite » Business Intelligence » JOINS bETWEEN SOURCE & TARGET (DATA INTEGRATOR 10.1.3)
JOINS bETWEEN SOURCE & TARGET [message #350401] Wed, 24 September 2008 23:32
singh.neerajin
Messages: 26
Registered: April 2008
Location: noida
Junior Member

Hi, I am using DATA INTEGRATOR 10.1.3 I would like to make a join between the source & target ( both are oracle database)

please suggest me.

acutally the query I would like to use is ..........


select a.catlg,b.catalog from
int_vlcusdata a left join cataloglookup_us
b on a.catlg = b.catalog and (a.desc1||' '||a.desc2) = b.description
where b.catalog is null

int_vlcusdata = source table

cataloglookup_us = target

I can use it in interface or in IKM
Previous Topic: Supplier site,Supplier contacts creation problem
Next Topic: ugrade discoverer from 90.4 to 10.1.2
Goto Forum:
  


Current Time: Thu Mar 28 11:15:22 CDT 2024