dbTalk Databases Forums  

About Fact tables and S_ETL_I_IMAGE table

comp.databases.olap comp.databases.olap


Discuss About Fact tables and S_ETL_I_IMAGE table in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rajat
 
Posts: n/a

Default About Fact tables and S_ETL_I_IMAGE table - 06-15-2007 , 12:24 AM






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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.