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

Oh, yes. Sorry. That option is turned on in the session object. However, it has only been turned on for the first target table - the one in the very first processing stream shown in the mapping (which may have a logical name of TABLE1 but the underlying physical table name would be the same...

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

Since we are talking "in theory" I'll step in with a comment. In my experience, the meta data definitions within an ETL tool (like Informatica) won't AUTOMATICALLY be invalidated because of a change to the underlying physical table... that's one of the beauties of having the meta data layer. If...

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

Out of curiosity, what was your answer?

Based on using v7.x, my answer is no. You don't necessarily have to follow Informatica's default actions. If the field you are talking about is not needed farther downstream, then in most cases, you can shutoff the output.

Wanted add a couple things to ClaireHsu's posting. Using version 7.x, I found that the port used for SETMAXVARIABLE() in an expression must be forwarded (outputted) to another transform otherwise it will not "fire". So what I mean in this example is, output the SETMAXVARIABLE port to another...

I get to answer my own question. Found this on Informatica knowledgebase: Problem Description: When using an Update Strategy Transformation does checking the forward rejected rows option cause the rows to be written to the session log or the reject file. Also if DD_REJECT is assigned to the...

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

bittmapp, here's my quick thought: I can't think of a way to have a dynamic filename in a mapping. However, one approach you could try is to always output to the same file and use a command task in the workflow to rename the file afterwards. - B

Thanks ArtieChoke. Works quite well now!!

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

Thanks MattOh. I'll have to look at both the ETL tool and db (Oracle). Will probably be some time but I will update the thread if I remember.

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

Hi nagrajm, Your example works fine by the "district" dimension and in fact is something I did to at least make the count work in that fashion. However, there is an additional element to orders that I did not make anyone aware of and that is a "unit branch". Each order can...

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

PaulBirch: I don't think I have enough info to answer your question about doing it right or wrong. I would like to clarify what you are saying regarding the dimensions your client wants and why you would need to duplicate (so it seems) the customer hierarchy in each dimension. Also, something...