Data Warehousing - Conditional Switching (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 25 FEB 1999 11:56:17AM Matt Sorrell wrote:

OpenInsight Specific

I'm wanting to data warehouse an AREV 3.12 table into SQL Server 6.5. My destination table is a de-normalized table due to internal requirements.

My MV field in the AREV table can have one of 10 possible values. The SQL column names are CODE_mvval. What I need to do in the warehouse script is inspect the value from the AREV table, and then decide which SQL column it needs to update.

The wizard does not allow for this type of conditional switching, and I am not familiar enough with the warehousing logic to figure out how to modify the generated script.

Any suggestions would be greatly appreciated.

Thanks,

Matt

At 02 MAR 1999 07:43AM Cameron Revelation wrote:

Hi Matt,

Just write a symbolic that calculates the value as you want to warehouse it, then warehouse that symbolic instead of the data column.

Alternatively, you would have to modify the warehouse procedure. (It is not hard at all … the whole point of creating the warehouse procedures was so that they would be customizable.)

Cameron Purdy

Revelation Software

View this thread on the forum...