DSXchange

So a script is out of the question? Then probably best to move it from the 'After Job' area to Execute Command stages in a Sequence job as long as those are allowed at your site. And yes, I'd suggest separate Execute Command stages so you can check the execution of the first and only trigger the sec...

It can really depend on your O/S and release as some add 'rename' or 'mmv' as a command line function (in addition to mv) that are multiple file rename friendly. For a series of steps like renaming all files (which generally takes a for loop) and then archiving to a new folder, I'd suggest a script ...

Not quite sure what you mean but since you can only have one group there, then yes but only if the 'different' columns are a subset of the grouping columns on the leading edge.

Or at least that what I'm thinking. Would have been easier just to say no.

Post your code - stage variables, constraints, everything involved in these checks.

Maybe this is the Old Server Guy in me but I'd just use a Transformer rather than Copy/Modify to split the stream. Why the 'grouping'... is that supposed to resolve the duplicates issue? You're worried about dups in the stream or in the target?

prahul4all

You need to start doing something helpful other than pimping your own website or your account will be banned.

Unfortunately, that doesn't really add any of the details I was hoping for but rather just repeats what we already know. Since nothing of what you posted is obviously wrong, this seems like something that would require "boots on the ground" to figure out... in this case I would suggest you...

That is strange... I would involve your official support provider on that one.

With the MKS Toolkit which comes with DataStage (or equivalent) installed you should be able to execute 'UNIX' commands like this. There is no native Windows equivalent that I'm aware of.

Of course, you could get your hands on any number of free 'hex editors' that are out there for DOS / Windows.

Still not seeing anything wrong so we're still missing something here. What else can you tell us about this? Even the smallest detail might help.

OK... this is the kind of thing that would require 'eyes on' to figure out. Ah well.

Not sure but might depend on your definition of 'conditional' - can you give us some examples of what you'd want to do based on a variable? What would vary? Do they all have the same metadata?

<edit: removed bogus target suggestion>

What about the File -> "Estimate Resource" option in the DataStage Designer?

Yup, what on other boards we would call a "thread necro".