Friday, June 15, 2007

A typical question

Please keep sending in your questions, it's interesting to see what challenges you guys (and Girls - Vicky!) face.

Here's a recent one

Hello Adrian,

I need little help.

Our company is implementing Oracle BI 10.x. We don't have much experience in Siebel Analytics/OBI.

We have few fact tables e.g. W_SALES_PICK_LINE_F, which we need/wish to extend. We are not sure about which methodology we should implement.
When we talked with few SA experts they mentioned we need to extend based on ROW_WID. Well, this column doesn't exists anymore in many fact tables, so currently we are thinking of creating ROW_WID on this F table manually and then create WC_SALES_PICK_LINE_FX and take these two tables in physical layer of RPD.

Additially, we need to create few Informatica mappings, again SA experts pointed out to use Image tables. Our data source is Oracle Applications, I don't have much idea about Image tables, but clearly there is not S_ETL_I_IMGAGe or so tables in Oracle Apps

Please guide us as how to proceed on these two issues.

Thanks in advance

and my answer

I am surprised to hear that ROW_WID has been removed from standard vanilla tables. I don't think your system will work without the ROW_WID field. Add the field back in quick! :)

My advice is to extend an existing table, not to create _FX tables. Providing you keep good control on your alter table scripts there are no issues with extending vanilla tables.

Take a copy of the vanilla mappings and customise these in your custom mappings folders. Do not update the vanilla mappings in place - they will be over written in an upgrade.

You can create your own image tables in the oracle db. The alternative is to use a last modified field in the table being imported.

You only need to create immage tables where there is lots of data, typically more than one million rows

Please can you send me more details on the project. It's good to understand where you are coming from, if you send me your rpd I can provide some feedback

Mobile: 07801 480900

No comments:

The Cowes

The Cowes
Cowes Racing