DSXchange

For a particulat key(id and name) i need to select the record which is having maximum start date and if it(start date) is null for all the records for that key i need to select based on end date Suddenly, the direction & nullability of the dates have reversed. :? Now we're just at an Aggregator...

That would be a question for your official support provider, me thinks.

From what I recall, there's a "beaker" shaped icon for this as well. It will depend on, however, how well you've used your saved metadata.

No clue. Explain more.

Fully explained in the Designer Client Guide pdf.

ps. No 'map'.

(sensing a pattern here)

Or leverage that in the Sequential File stage's Filter... minus the redirect.

Why not just google that or ask someone where you work? Not really a DataStage question, after all.

Hard to say. It can depend on the job design... do you always use all values generated or are some assigned and then blocked by a constraint? Or did the job fail and roll back some rows?

Add either -wait or -jobstatus to the command, either will cause it to wait. The difference between the two is documented in the Programmer's Guide pdf, as are all dsjob options.

All you changed were the 'a' and 'b', so (to me anyway) that doesn't really change anything as I assumed they were wrong in the first place. However, you really haven't done anything to clarify your requirement. "if it is null then i need to fetch the record based on St_Dt" No idea what th...

Server or Parallel job? What does your job design look like?

Hey, that's what I said. Just with less... code.

Split last like you are now and split out 'first middle' using comma as well, then (from the 'first middle' field) split first and middle based on the space with another field() call.

Isn't this restriction removed in the later 8.x releases?

Make sure you realize that you are replying to a six year old post discussing the 7.x architecture - the new world bears very little resemblance to the old world. Kind of a Christopher Columbus expression but still... Let's get you into your own thread in the proper forum. Edited to add: split from ...