DSXchange

harikhk wrote:In terms of construction effort I agree that option B is easier but what in terms of performance

What I said above was option B does less work (meaning better performance). You said it was easier, and I would agree with that too.

I would also vote for option B as it appears to do less work in order to produce the same result.

Decimals data types auto-pad with zeros; haven't seen that with integers.

You're welcome. I would hope you are able to get ISD licensed. Maybe if you ask nicely, they would throw in FastTrack along with your purchase.

I vaguely remember on a "what's new in v9.1" webinar there being reference to some new feature like this. Not sure if is this. Are you on version 9.1?

Check out this IBM Redbook and share it with your architect.

IBM InfoSphere Information Server Deployment Architectures

The license costs and performance depends on which tier or tiers you are talking about, and what type of HA you might configure (lower cost active-passive vs. an alternative). There are so many topology and HA variations to choose from. One HA consideration is automatic vs. manual failover and wheth...

I believe that "active-active" is what the doc refers to as "fully clustered." You license according to what is active.

On the command line, you may be missing the -I option in front of the include path provided. Try inserting -I with no space.
This topic shows a compiler command where two include paths have been referenced.

Initially metadata is imported into IA. After that you can run column analysis or other types of analysis on the actual data. The analysis results are stored and available for further review, like a snapshot. If the source metadata (table structure) changes, my experience has been to import the new ...

You may need the 64-bit client installed before you install the fix pack. Not sure if it has to do with the bit-ness or not... Can you share the error?

What version of the update installer are you using, and is it the newest?

Information Services Director (ISD) is a separately licensed product component (vs. the products you listed).

Try using absolute paths (give full path for each .h file) rather than relative paths. Relative paths are only relative to the current working directory, which can change.

I'm not sure if it can be done within one job in a more elegant way, short of working a support case. Escaping the tick marks with backslashes or more tick marks doesn't help. You could try more variations using single quotes, double quotes, or other special escape characters. This may be less elega...

If the incoming value were 12/33/2013, it should flag it as an invalid date. Try adding a reject to route the invalid date values for review.

If you anticipate an upcoming bad date, you may want to propose to meet on an invalid date.

I hit something similar on 8.7 (same error code, different return code, different details). I had to contact IBM Support, open a PMR, and they guided me through a manual workaround. I suggest you check the installer's log files and if nothing obvious jumps out to fix, then contact your product suppo...