Home » Developer & Programmer » Warehouse Builder » JOINS (DATA INTEGRATOR 10.1.3)
JOINS [message #350066] Wed, 24 September 2008 00:25
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: How to run mappings from Unix ?
Next Topic: Issue with UNdo Talespace
Goto Forum:
  


Current Time: Fri Aug 01 08:07:25 CDT 2014

Total time taken to generate the page: 0.10260 seconds