DSXchange

ray.wurlod

Maybe, maybe not.

Get them to define "performance" first.

The KPI in ETL is the ability to complete the task in the available time window, with a safety margin.

Rate metrics are of little use. Rows/sec is particularly meaningless.

ray.wurlod

The '"#" thing' doesn't work in routines.

About the only alternative is to call the "UniVerse" command ENV from the routine and parse the required result from the dynamic array that returns, probably using a FindStr statement.

ray.wurlod

LongVarBinary is not a supported data type.

ray.wurlod

It's only a few cents per day, and is 100% devoted to bandwidth charges incurred by DSXchange. It IS worth it!

ray.wurlod

Code: Select all

Convert(Char(0), "", InLink.TheString)

provided that the target field is VarChar - if it is Char it'll just get filled again!
Or you could change the default fill character using APT_STRING_PADCHAR

ray.wurlod

Are you typing in the project name or choosing it from a drop-down list? (Project names are case-sensitive as well as needing to be spelled correctly.) Can you connect to the project with any other client? Are you indeed authorised to connect to this particular project (whether or not the dstage gro...

ray.wurlod

What precisely do you mean by "lookup with wildcard"? The explicit value "***"? Or all possible area codes? The latter isn't possible with a Lookup stage.

ray.wurlod

ekempd wrote:without having to pass it as a parameter

ray.wurlod

Same rules as SQL - every input column must either be grouped or have an aggregate function applied. Think about it - fewer rows out than in, because of grouping. From which input rows would your passthrough columns be selected? You could create a "fork join" design - split your data into two stream...

ray.wurlod

There's a fifth, empty line, caused by the final line terminator.
Take the leftmost (N-1) characters of the command output, where the command output contains N characters.

Code: Select all

Left(EC.$CommandOutput, Len(EC.$CommandOutput)-1)

ray.wurlod

Your assertion is not correct. The Condition in a Lookup stage typically IS based upon value(s) from the stream input. For only a few cents per day you can obtain premium membership. Revenue from premium memberships is 100% devoted to servicing bandwidth charges needed to keep DSXchange operational.

ray.wurlod

Yes, but no really safe way.

There is a command to quiesce the Repository database (SUSPEND.FILES), but that has the same impact on users as shutting down the DataStage services.

The uvbackup utility can perform an "on line" backup, but waits if any record it needs to back up is locked.

ray.wurlod

Well done. I was asleep the whole time!

ray.wurlod

Code: Select all

grep -w 'MY PET' filename | grep -v DOG | grep -v CAT

ray.wurlod

Use stage variables in a Transformer stage to detect change; if there's a change set the counter to 1, if there's no change increment it.

Search found 53125 matches