Search results for query: *

BO version - 6.5 I add/change/create groups and users for our BO environment. An annoying issue we have is that if I make changes to groups or users or access to documents in Supervisor, the changes are slow to "refresh" on the BO web portal. A previous admin apparently knew of a command that...

INFA 6.2 ORACLE 9.2 Mapping is required to call a function fnName(in_Voucher,out_ResultCode,out_ResultMessage). The function is embedded in a package. I tried using the Stored Proc transform to call this function (when I use the SP Import, it does see it) but I am getting an error similar to...

I have the following situation in mapping (Informatica v6): Source -> SQ -> Expression -> Target Source -> SQ -> Expression -> Target Source -> SQ -> Expression -> Target Source -> SQ -> Expression -> Target Each source is different but the target is the same table (just renamed logically...

I've been looking out for contract work for Informatica and have some experience on version 7. I've seen some jobs that specifically mention v6 and am wondering how much different the two are? Is my v7 experience pretty much completely backwards applicable to 6?

Wanted to poll the audience to find out if anyone can think of where I could find some decent sample data (representing a source system) which I can then transform into a dimensional model. The only thing I have thought of so far is the Northwind database and possibly sample db's in db installs...

Just curious if anyone has found a way to avoid having rejected rows (i.e. coming out of an update strategy) not get written to the session log. I did try setting the property on the update strategy to both "forward rejected" and that option unchecked. In both cases, rejects got logged. The...

Am making use of command tasks in a workflow to run shell scripts in AIX/Korn shell. I'm not much of a korn shell expert but have found sample code that tests the last run command status ($?). If not zero then I've coded "exit 1". In testing this, I see in UNIX that the return code is 1...

In the latest Data warehousing Toolkit book, Ralph Kimball suggests using a CRC algorithm as a fast way of checking if one or more attributes of a dimension have changed. I have no idea how to implement a CRC process. Does anyone know? What other methods do people use to detect if an attribute...

Am not having much luck coming up with counts for the fact table I am using in a PP cube. The goal is to have a count of one per order however the granularity of the table is such that there can be multiple records per order. One thing I have thought of but haven't figured out how to do is...