Search results for query: *

Hello OWB experts, Here is the situation: I am loading (successfully) ASCII files from a UNIX server onto Oracle 8i database. Also loading dimensions and facts successfully. I have set up OWB reposirory and Runtime repository in Oracle 8i as "Owbdev" and "Owbrun" oracle...

Thank you, for your assistance MattOh!

I have used the SQLTXT Designer in Decision Stream which I find very easy in use and provides good functionality. Please assist in the following: In case that my TXT files exist in a remote location is it possible to use ftp in DS in order to "read" txt files from a remote machine...

Thank you, MattOh! Your answers are really very helpful! "I'm guessing Customer_ID doesn't even exist in your source system tables, is that right?" Well, this is not the case; in fact the source tables also have CUSTOMER_ID as primary key... But I found your explanation of how DS...

Yes, you are right MattOh, I am trying to implement Type 2 Slowly Changing Dimensions but - as i think - in a very particular way. 1. I have a CUSTOMER table (target) which has a primary key (CUSTOMER_ID) and an alternative key CUSTOMER_CODE. This table is populated from two other tables...

Hi, Decision Stream experts Please assist in any of the following problems: 1. I want to build a dimension where the primary key (business key) will be generated (Max[primary key] + 1) only when new rows are inserted, 2. I am looking for a way to have conditions on UPDATE/INSERT for example...

Thanks MattOh, That was the case indeed! The message was related to having a proper authorization key for DecisionStream. Regards, Loukas

I am new to DS though I have experience in other ETL tools. I am trying to execute several dimension/fact builds -- even builds from Cognos manual (DS_Lessons Catalog) -- and I am getting the following failure messages in a dos-command window: when I try to execute dimension build...

Thank you blom0344 and xuewei for your answers. I agree with blom0344 that DECODE is Oracle's "if" statement. I also agree with xuewei that DECODE doesn't work in OWB as i have tried to use it. I am trying to understand if OWB supports and how the "logic" that i am...

Anybody has used a "if then else" statement in Oracle 9i Warehouse Builder? Have you find a workaround? I guess it is possible to write a transformation or procedure ... Thanks a lot for your answers...