Search results for query: *

Check your event log for detailed error messages. Rgds. Juergen

Check your SQL Override! You seem to use an overrided SQL which does not match the columns in your Source Qualifier. Rgds. Juergen

Hi, I try to update a cube description by using ppadmtool and get the following error: Message file read error, message id is 1102. Thanks for any comments. Juergen

Hi! There is an option called "Inclusion" on the "General" tab of the level properties. Set it to "Always include". Juergen

Hi, did you check out the event viewer for error messages? You need to look at the applicatio event queue. Rgds. Juergen

Hi, a few basic tips: - you need about 1,5 CPUs per (unpartitioned) session - memory requirements depend mainly on the size of lookups, joins, aggregations, sorts. Try to avoid disk caching by increasing the shared memory size parameters. - avoid network bottlenecks, install your Informatica...

Hi, The problem is that PowerMart does a binary ftp transfer. The mainframe certainly uses EBCDIC encoding. Therefore the file must be converted into ASCII while transferring. Most ftp tools can do that if you use ASCII mode transfer. Unfortunately PM does not enable you to change the transfer...

Hello Matt! There are many ways of improving the performance of your load. First of all you can drop the primary key and recreate it after the load. You simply use a script which is called in the pre session command to drop the index and a script in the post session command to recreate it. If...

Hi, you can use a non-cached lookup either in the session or in the mapping. Just unmark the "Lookup caching enabled" option on the Transformations tab. If possible, consider using the lookup table in the source qualifier as a source table. If you do so, the lookup table will be...

Hello! Has anyone ever tried using orabulk stage in conjunction with a named pipe in UNIX as a target? I want to avoid first writing the data file and in a second step having to execute sqlldr. With a named pipe I assume I could do it in one step by letting DataStage write into a named pipe and...

Try this: sum( iif( prod type = 'abc', order_value, 0 ) ) = Measure 1 sum( iif( prod type = 'def', order_value, 0 ) ) = Measure 2

If you find one please let me know :-)

There is a standard for metadata interchange calle JMI (Java Metadata Interface). You can find information about it at http://java.sun.com/products/jmi/. Furthermore some datawarehousing tools offer Java-based APIs for accessing their metadata (e. g. DT/Studio from Embarcadero).

Contact your local Informatica sales office. There's no official download source for trial versions

Hi! I have an existing cognos application with Upfront, PPES and IWR. Additionally I developed some JSPs for administrative tasks (status of DB tables, materialized views etc.). The problem is that these JSPs are stored on another server without any authentication mechanisms. So if a user finds...

Hi all! I've just upgraded to Series 7 and noticed that the ppserver process is taking away a whole cpu even if no user is logged on. How can this be? Is there a way to avoid this? And what the heck is this process doing? Thanks. Juergen