Transaction type and Array list

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Magesh_bala
Participant
Posts: 86
Joined: Mon Nov 27, 2006 3:42 am
Location: Wilmington

Transaction type and Array list

Post by Magesh_bala »

Hi All,

Please clarify what is the difference between Transaction type and Array list.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

In what stage type?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Magesh_bala
Participant
Posts: 86
Joined: Mon Nov 27, 2006 3:42 am
Location: Wilmington

Post by Magesh_bala »

ray.wurlod wrote:In what stage type? ...
Oracle Stage...
rafik2k
Participant
Posts: 182
Joined: Wed Nov 23, 2005 1:36 am
Location: Sydney

Post by rafik2k »

Array size: no.of rows written to or read from the database at a time.
Transaction type: no. of rows committed at the database at a time.

Default value of Transaction type is 0, means all rows will be committed at a time
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

There's no 'Array List' in the Oracle stage.

Another generic interview-like question. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

I think its about time we have an "Interview Questions" forum out there, just for the heck of it. This is the only area that seems to be all over the place. We can call this forum Leecher's Hot Spot, or maybe thats too harsh :roll:
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

chulett wrote:There's no 'Array List' in the Oracle stage.

Another generic interview-like question. :?
There's no "Array List" in ANY stage type, which is what motivated my question. I thought I may have missed something. So I believe we're dealing with a beginner here, who meant to type "Array Size". In which case rafik2k's answer is exactly what the OP would have found by clicking the Help button in the stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply