DSXchange

If i add key K5 in partition column will data get repartition? Yes. But think about what partitioning is doing. Given that the data are already partitioned on K1,K2,K3,K4 then every combination of {K1,K2,K3,K4,K5} will be on the same partition as {K1,K2,K3,K4}, if you don't include K5 in the partit...

Make sure that the string that you construct satisfies the format specified in your timestamp format string (default value can be viewed on Parallel tab in Administrator client) or provide a non-default format string in your StringToTimestamp() function.

IBM is running a QualityStage training class (DX741AU) in Sydney (Australia) from July 6th to July 9th 2010.

There are still vacancies available.

And if it's not owned by that user?...

At current version (8.1 and earlier) retrieving the value of a user variable within the same User Variables activity is not possible. But there's nothing to prevent you using two adjacent User Variables activities.

This one might get messy in a grid environment!

Welcome aboard. That's a perfectly reasonable question. The trick is to make the string into a "dynamic array" using a special delimiter for the line break. Most people like to use the "value mark", which is available as the system variable @VM. Hence: Call DSLogInfo("Execut...

Don't believe everything sales people tell you. Version 8 uses both repositories. The common metadata repository is shared with other tools, such as FastTrack, Metadata Workbench, Data Architect. The local repository is used primarily at design time and, optionally, for job log storage.

Are you able to do anything at all with Connectors (such as import a table definition)? If not it might be an issue with the Connector Access Service, rather than with the DSN definition. Connectors use a "funky method using Java and XML" (to quote a very knowledgable IBM support analyst) ...

Until recently the 8.x release required that the itag be the default value (ade). However, I have just installed a system where the itag was prompted for, which makes me assume that a non-default itag value is now possible. Even so, there is so much that is different in version 8 I would continue to...

Before this function can be called in the SCD stage, the column whose derivation it is must have its purpose assigned as "Surrogate Key". My guess is that you have missed this step.

This question must be asked - are you using any routine that invokes BCI functions?

Why not have multiple outputs from the CFF stage to receive the different record types?

Can you ping the SQL Server host machine from your production server?

Is connectivity blocked by a firewall setting?