DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
skp



Group memberships:
Premium Members

Joined: 26 Dec 2007
Posts: 135
Location: India
Points: 1335

Post Posted: Tue Dec 23, 2014 3:36 am Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi,

Which stage among the four stages below consumes less memory at the time of joining two inputs data --- Merge/Funnel/Lookup/Transformerstage? Could some one explain with little bit explanation please?
priyadarshikunal



Group memberships:
Premium Members

Joined: 01 Mar 2007
Posts: 1735
Location: Troy, MI
Points: 9319

Post Posted: Tue Dec 23, 2014 6:09 am Reply with quote    Back to top    

funnel and transformer are not for joining data. Unless you taking server jobs as well in to the consideration. What you exactly want to know for these 4 stages.

Out of curiosity, is it an interview question?

_________________
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. Wink
Rate this response:  
Not yet rated
skp



Group memberships:
Premium Members

Joined: 26 Dec 2007
Posts: 135
Location: India
Points: 1335

Post Posted: Tue Dec 23, 2014 6:29 am Reply with quote    Back to top    

THanks Priya.

Sorry the four stages are Join/Funnel/Lookup/Merge stage. Yes it is interview question but it does not matter i believe.
Rate this response:  
Not yet rated
priyadarshikunal



Group memberships:
Premium Members

Joined: 01 Mar 2007
Posts: 1735
Location: Troy, MI
Points: 9319

Post Posted: Tue Dec 23, 2014 7:40 am Reply with quote    Back to top    

First of all Funnel does not perform join operation, it is similar to "Union all" in SQL. It does matter if its a interview question as we here in dsxchange strongly believe that the interview questions should be answered based on ones experience rather than re-iterating someone else's answer. But for your truthfulness below are the pointers.

The other 3 Join/Lookup/Merge stages can perform tasks of SQL joins. Please read parallel job developer guide where they have sections like Join Versus Lookup etc which should give a proper idea on their functionality and Memory uses.

To start with the lookup uses RAM to store data coming from reference link while others use disk to store the same.

_________________
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. Wink
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