Home » Developer & Programmer » Data Integration » 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

Report message to a moderator

Previous Topic: How to run mappings from Unix ?
Next Topic: Issue with UNdo Talespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 14:37:22 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.