DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic is not resolved, but there is a WORKAROUND.
Author Message
KPReddy
Participant



Joined: 25 Jan 2006
Posts: 28
Location: Philadelphia,PA
Points: 234

Post Posted: Wed Oct 15, 2008 12:33 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,
In my job i need to join a parent column from DataSet to child records in DB, The DB table is big, so i ruled out normal lookup but sparse lookup does not allow multiple records from reference link.
How can i use a query like
select * from child table where col1=ORCHESTRATE.col1 and join to parent record.
Thanks in advance
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Wed Oct 15, 2008 1:19 pm Reply with quote    Back to top    

A sparse lookup does not allow multiple reference links, as far as I know it still allows multiple rows to be returned by a link.

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
shamshad



Group memberships:
Premium Members

Joined: 25 Aug 2004
Posts: 147
Location: Detroit,MI
Points: 1383

Post Posted: Wed Oct 15, 2008 2:17 pm Reply with quote    Back to top    

If you are allowed to create a temporary table in Oracle, dump the dataset data into a table where the child oracle table resides and then push down the join operation as SQL between both tables, the temp table as outer joined table.

_________________
Datawarehouse Consultant
Rate this response:  
Not yet rated
shamshad



Group memberships:
Premium Members

Joined: 25 Aug 2004
Posts: 147
Location: Detroit,MI
Points: 1383

Post Posted: Wed Oct 15, 2008 2:19 pm Reply with quote    Back to top    

If you are allowed to create a temporary table in Oracle, dump the dataset data into a table where the child oracle table resides and then push down the join operation as SQL between both tables, the temp table as outer joined table.

_________________
Datawarehouse Consultant
Rate this response:  
Not yet rated
KPReddy
Participant



Joined: 25 Jan 2006
Posts: 28
Location: Philadelphia,PA
Points: 234

Post Posted: Tue Oct 28, 2008 12:27 pm Reply with quote    Back to top    

Thanks Shamshad. I had the oracle table as an option, went ahead with that as i could not find any other alternative.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours