Search results for query: *

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...

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?

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...

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...

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...

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...

FYI in case anybody's interested. A chart in the documentation says that on a flat file target definition, you use Field Length, not Precision and Scale, to define the total length of Number fields (allowing for minus signs, decimals, and separators). It says you use Precision for text fields...

I am trying to get a lookup by ID that would give me a minimum value from one of the source tables: Select ID, Min(value) From table where value = 0 group by ID. I get Invalid Lookup Override even though the SQL itself validates fine (actually the sql is large, this is a simplification)...

My source file is tab delimited. Some places it has Tab, Null, Tab (09, 00, 09 in Hex). As soon as Informatica hits that sequence, no fields in the rest of the row are loaded. To me, it should load the Null and keep going. Access and Excel have no trouble with it; the whole row loads into...

Is it possible to do a lookup from a flat file (e.g. I would cache the contents of the flat file and do the lookup into it)? Seems like it should be but from doc and the lookup transformation creator, doesn't look like it. The Import requires ODBC, and Source browsers only pick up the database...

I imported 3 sources from a flat file (e.g. sample1, sample2, sample3.csv). The actual data files have different names. Now every time I set up a session (often, since we set up a special session for debugging), they default to "sampleX.csv" file names. I cannot see anything in the source...

a) The email task shows variables (like %l) available for the email text, but doesn't seem to work. It comes in as a literal "%l". Are they just there to fool us? b) Is there any way to get a user-defined workflow variable into the workflow email task? Even if a) worked I'd really want b)...

I am thinking of using a reusable sequence generator for a cycle of 22 sessions in one workflow, each of the 22 using the same mapping. The sequence generator would tell the mapping which iteration it is on, which I would use for some of my transformations. I can Cycle it at 22 so it should...

I need to get information from an Oracle view. I see it in the Link Tables list, but cannot attach it because it says "There are several tables with that name. Please specify owner in the format 'owner.table'." But there's no place for me to type in the owner name and it doesn't...

I want a single max value of a certain non-related table to be plugged into a field in each row generated by the mapping. There's nothing to join to or look up by, so it doesn't like joiner or lookup. Really I just want it to act like a system variable. Putting Select Max() as the SQL query...