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
rhaddur
Participant
Posts: 52 Joined: Mon Mar 13, 2006 7:33 am
Location: mumbai
Post
by rhaddur » Mon Mar 19, 2007 6:38 am
What is run time column propagation ?
Rhaddur
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Mar 19, 2007 7:26 am
An interview question. And a trick one if used in the context of a Server job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Mar 19, 2007 8:32 am
I'd be interested in 'its' implemention in server jobs
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
mehimadri
Premium Member
Posts: 25 Joined: Sat Jan 13, 2007 4:56 am
Location: United States
Post
by mehimadri » Mon Mar 19, 2007 12:32 pm
U can define part of ur schema and specify that if ur job encounters extra columns that are are not defined in the meta data, it will adopt these columns and propagate them thru the rest of the job.
I have seen them in sequential, file sets and almost every other data source stage in parallel jobs, but not in server ones.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Mar 19, 2007 6:54 pm
DSguru2B wrote: I'd be interested in 'its' implemention in server jobs
That's an easy one. 's impossible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Mar 19, 2007 7:56 pm
Me know that. Was just playing along the 'tricky part'
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
pravin1581
Premium Member
Posts: 497 Joined: Sun Dec 17, 2006 11:52 pm
Location: Kolkata
Contact:
Post
by pravin1581 » Fri Mar 23, 2007 7:10 am
DSguru2B wrote: Me know that. Was just playing along the 'tricky part'
Do we need to define the metadata in the colums tab of the file stage?
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Fri Mar 23, 2007 7:32 am
Always, for server jobs. For px jobs, if any transformation is required with rcp turned on, then yes, else no.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.