DSXchange

What database? Can you be more specific as to the "timestamp" source and target columns - what exact data type are they? And a specific example of what "slapped with" means would be nice.

Any "performance loss" with upserts is typically due to full table scans. Are there indexes in place for the where clause columns? Stats up to date?

cherry wrote:Let not confuse with the sample data above.

Best way to not confuse people? Don't post "simple" or made up sample data, make sure it is representative of the actual data. That way people don't post invalid answers.

As to your "any idea" question I'd already posted a solution.

Perhaps just a call to DSLogFatal() depending on the outcome of the output variable check?

DSparam is automatically created for you. So what exactly have you been tasked with? Do you have an existing project they want you to transfer DSParam information from?

DIR /B is a "bare" listing of filenames, equivalent to "ls -1" in UNIX. An "ls" with the "-m" option actually creates a comma-delimited list of filenames, ready to go. Hence the recommendation. Regardless, you'd still need to deal with the Field Mark at the end.

I would ask if you finally involved support but worry it would be two or three weeks again before the answer came. And I have a funny feeling we already know the answer...

I'm curious what exactly you tried for step 3 and what "it's not working" means. Also, are you familiar with the $Counter functionality that Ray mentioned? The examples in the documentation are decent and an exact search here for that should turn up a number of previous conversations on th...

eostic wrote:They might mean escaping them in various ways as per xml rules....so that a '<' comes thru escaped as < or '&' becomes & .

Which is what I meant when I said made "safe"... could have sworn that was the term for that substitution.

I'm guessing your example posted is not representative of the actual data, if it was you'd just use the BENEFIT to number the ENTITY_ID. Meaning there'd be no reason to generate or increment anything. However... Use a Sort stage to get the data into the proper order and have it generate a Key Change...

ON the subject of deleting old job logs in the &PH& directory. The problem is the files in the "phantom" &PH& directory are not the job logs. They are files used to communicate the status of the background processes that all jobs run as. That's why the recommendation is to...

It wasn't my issue, so no.

Best to start your own post on the subject with the gory details of your problem.

Well, here we are in the correct forum now...

More than likely that is the issue. Fix the division error and you'll see.

You're outputing 'decimal' fields to the flat file, I assume. From what I recall, those are written in binary and the DataStage options you are using to display them are aware of that and convert them for you when they display the fields. The raw file viewed 'in UNIX' will not be able to display the...