DSXchange

Have you looked at the Sequence jobs in Production to see if your actual changes made it there? How exactly are you exporting/importing your jobs? A 'normal' import from the GUI automatically deletes the original job before importing the replacement so it doesn't surprise me that doing that manually...

Sequence jobs have no issues running combinations of Server and Parallel jobs, that is their function. And I don't see any need for the Nested Condition stage (unless there is an actual 'condition' being checked in it) as $UserStatus can be passed directly between the two Job Activity stages.

As noted, a pivot.

You got exactly what you coded when you simply appended the new value to the current file. In order to "update" the values file, you'd need to read it and then write it out with that specific record replaced with the new value to a new filename and then replace the original file with the n...

Three steps:

1. Do an exact search for DSSetUserStatus
2. Read thru the matching posts
3. Implement!

While 201107* may work in UNIX, it won't match files in Windows without specifying an extension as well - meaning 201107*.* would be what you should try. I don't think it will help but can't hurt to try. Now, I'm curious - why the UNC path? Are you looking for files on a remote server? I wonder if t...

Start your own post, give us the gory details of your problem.

I honestly have no idea but I don't recall having an ODBC name with a space in it, for grins you might want to try a name that doesn't include one.

I'm not sure what kind of information you are looking for. How do you convert any X to Y? You determine what X is doing and you then build the same thing in Y. There's no magic here. Do you have design documents, source to target mappings or just the Informatica mappings to work from? Are you famili...

For example, this Redbook and/or this one.

Answer the question Ray asked - do you change the method from Specific File to File Pattern when you use the wildcard character?

The date format required into the target is MM/DD/YYYY The date format in the source is DD-MON-YYYY Just want to point out, for the umpteenth time, that dates do not have a "format". As James noted, all of those are external formats, what you get after you select a date as a string, somet...

You use the function in a BASIC routine and then point it at a finished PX job from a Sequence or the After Job area of the job.

Yes, WebSphere Transformation Extender (the product formerly known as "TX" and "Mercator" before that, which for all I know has a new name now) is a separate purchasable tool. Yes, the XML format should be perfectly digestible by DataStage and perhaps even the "proprietary&q...

Depends of the "this" you are asking about. As Ray noted, you can let the Sort stage add a "Key Change Column" to the data which makes it trivial to know the first record of a group. If you are already sorting the data, it would be a little more efficient to take this path but I ...