Recent content by pbackstrom

When I choose Database / Options / Document / Show Physical, the data types on a Database design document I did from scratch show, for instance, "Int", while when I reverse engineered from SQL2005, they are "INTEGER". I'd rather have them say "int" if I have a choice, or at least know how to...

Thanks. Yes I was term-served directly to the server, will keep this in mind for the future. I wound up cutting the query, replacing it with "Select 1", saving it (which it accepted), editing the original query in notepad, then pasting it back in. That wound up working too.

We just upgraded to SP4. When I opened a DTS Transformation Task and pressed OK to save, it closes the entire Enterprise Manger window without saving the task changes. Any hints?

Possible cause: Filter that preceeded it had a data type error in a port. Not sufficient to prevent the row from showing up in the target instance, and not sufficient to error out the workflow, but fixing the type error seemed to result in getting Insert as row type.

Mapping with a normalizer, loading parent and multiple child rows. Constraint based loading in session is checked. Treat source rows as Insert is checked. Update as Update either checked or unchecked. In Debugger, it "writes" a row to the target window for the parent, but ROW-TYPE is...

Also you can use Target Load Order in the mapping - Mappings Target Load Plan if you want to control not having them sequential within the mapping. It goes by source qualifier.

Never Mind. It was a Case Sensitivity problem. Case Sensitive is not checked in my lookup transform, but it was treating it as case sensitive anyway.

No, normally the mapping has its own copies of each object. When you say "source/" what do you mean? Sources are edited in the source analyzer, not the mapping, and changing a source in your folder would affect all the mappings that use that source. If you have reusable objects then editing...

My lookup (from an Oracle table) fails whenever the field that it's supposed to match begins with an asterisk. That is, key of *AB12J will not find *AB12J in the lookup, returning null. Anybody hear of this or know a setting to change? I can try chopping off the incoming * and do a substr in...

I would like to have a variable store a value from one record to the next. That is, store a value from the first record, and compare it to the value in the next record coming in. I tried a wide assortment of things using mapping variables but it seems that even if I use a SETVARIABLE on every...

Just burned a few hours tracking down an overflow error so thought I'd share the results (for anyone doing keyword search in the future). Was getting overflow errors in my session logs. Debugging using an existing session and stopping on the offending records yielded no clues. Ran in debug...

FYI (anyone), I took the time to rewrite it as lookups, for future maintenance sanity. It runs in half the time. None of the files are large (1700 records), YMMV, but thought it was interesting. Hurray for flat file lookups.

I am joining many flat files into a single table. I have a series of joins (a to b, then ab to c, then abc to d etc). I am wondering if one driving table with a series of lookups would be any better or worse for performance or for any other reason. It would sure make the flow through the...

Found one. Guess it says what to do. Thanks. FATAL ERROR : Unexpected Condition in file [/stress/home1/build65/pm71n/common/utils/pmdata.cpp] line [125]. Contact Informatica Technical Support for assistance. Aborting this DTM process due to an unexpected condition.

In debugging, I get Server acknowledged the request to step to next instance. Failed to receive a notification from the server: Shutting down notification handler due to previous errors. It's happened in a couple of different mappings, both when using an existing session and in creating a...