tag:blogger.com,1999:blog-33209370.post7800370137809062320..comments2023-10-23T17:52:37.156+00:00Comments on Oracle Analytics: Questions, QuestionsAdrian Wardhttp://www.blogger.com/profile/12467688997292586407noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-33209370.post-33737120459260687882007-05-25T15:03:00.000+00:002007-05-25T15:03:00.000+00:00Well lemme try answering ur questions :)W0 Warehou...Well lemme try answering ur questions :)<BR/><BR/>W0 Warehouse<BR/><BR/>W1 What schemas do you recommend for an Analytics system<BR/><BR/>A:Start Schema??<BR/><BR/>W2 How do you save changes to data in SQL<BR/><BR/>A: ?? Tool specific. depends which tool u r using or u mean Update statements ???<BR/><BR/>W3 What is the structure of a PL/SQL script<BR/>A: Declare<BR/> Begin<BR/> Exception<BR/> End<BR/><BR/>W4 What tools do you use to manage databases<BR/>A: Again depends, Toad for Oracle & DB2 , MS SQL ......<BR/><BR/>W5 What is the difference between an OLTP and an OLAP<BR/>A: OLTP is the transaction system where the transaction records are stored. You can report of what is happening currently.<BR/>OLAP system is the system created from OLTP system for Analysing the trend. Not for reporting whatz happing currently in the org.<BR/><BR/>W6 Do you use indexing on a staging table?<BR/>A: No . Its because staging table are used to store the data which needs to be loaded to Warehousing. Stagin tables are always truncated. It doesn't store the history and the load is always insert..<BR/><BR/><BR/><BR/>I0 Informatica<BR/><BR/>I1 How do you call a stored procedure in Informatica<BR/>A: Stored proc transformation<BR/><BR/>I2 When do you use re-usable objects<BR/>A: When the same object is used in multiple places. For eg: Lookup to a dimension to get the surrogate key. It will be used in all the Fact mapping where the Dimension key is present.<BR/><BR/><BR/>I3 Where do you create your own mappings in the Siebel Informatica Repository<BR/>A: Mapping Designer<BR/><BR/>I4 How would you add a field from S_ORG_EXT_X to the warehouse<BR/>A: Siebel OLTP specific. depends on me. I can use the X_Custom port available in the mapping and the target table or can create a new port.<BR/><BR/><BR/>D0 DAC<BR/><BR/>D1 What is the main purpose of the DAC.<BR/>A: Its a gr8 tool. I lekd it very much. It reduces the manual effort to create the workflow and worklet. Also it saves time by avoiding runing unnecessary sessions.<BR/>For eg: 2 mappings are loadin data into Status dimension: One for Sales Status & other for PO Status.<BR/>Now in the conditional table i can give the respective Fact table for Sale & PO.<BR/>If i include both the facts in my subject area then both the dimension mapping will run. If i include only Sales fact then only Sales status will be loaded...<BR/>This is one of the benefit.. there are many.<BR/><BR/>D2 What objects are in the DAC.<BR/>A: Again depends which version u r using, in Latest release(Tenerife) Table, Tasks, Tasks Group, SA, EP. Before this Table group were there in place of Task group<BR/><BR/>D3 How do you add an Index for a table (existing and not existing)<BR/>A: Go to Table add and then Indices for that and then Add. If existing you can import from DB.<BR/><BR/>D4 How do you run a full load (not incremental)<BR/>A: Reset data warehouse . But i do it at the back end :). Just truncate the S_ETL_REFRESH_DT table in the dac repository<BR/><BR/>D5 How does Change capture work<BR/>A: Again Siebel specific. If u have Siebel OLTP then the concept of _I, _R, _D comes into picture.<BR/>_I stores all the records which needs to be inserted. _D stores all the records whic needs to be deleted, _R stores all the history. ( These table stores only INtg ID, Datasource NUm id, one more column which is running no. forgot the name for each operation :))<BR/>Change capture takes all the records from _I & _D.<BR/>_I is populated by joinin OLTp tables & _R tables. once the data is loaded into staging all the data in _I table is moved to _R image.<BR/><BR/><BR/><BR/>Con0 Analytics Config<BR/><BR/>Con1 Where do you change the config settings<BR/><BR/>A: nqsconfig file <BR/><BR/>Con2 How do you turning caching on<BR/>A: NQSConfig file<BR/><BR/>Con3 How do you add a new style<BR/>A: add a new style in OracleBIData\Wed\res.<BR/>Maui release has an issue, you need to add the style in OC4j folder also.<BR/>\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics<BR/><BR/>Con4 What default logging level is best for a 1000 seat company?<BR/>A: 2 ?? Not sure <BR/><BR/>R0 Repository<BR/><BR/>R1 What are the three layers<BR/>A: Physical, BMM, presentaion<BR/><BR/>R2 How do you set session variables and how do you set Repository variables?<BR/>A: Manage>> Variables<BR/><BR/>R3 How do you update alias table definitions?<BR/>A: Once you update the main physical table, aliases will be updated automatically.<BR/><BR/><BR/>Web0 Webcat<BR/><BR/>Web1 How do you copy requests from one webcatalog to another?<BR/>A: Open catague online in catalogue manager, copy (Copy to another catalogue), open the other webcat then paste ( paste from another calogue)<BR/><BR/>Dash0 Dashboards<BR/><BR/>Dash1 How do you create a dashboard?<BR/>A: in Answer go to Settings>>Administration>> Manage Dashboard.<BR/>Is it required to rememeber this :) <BR/><BR/>Dash2 How do you set the permissions on a dashboard<BR/>A: Settings>>Administration>> Manage Privileges.<BR/><BR/><BR/>Ans0 Answers<BR/><BR/>Ans1 What is the Formulae to use in a request, to see a Repository Variable?<BR/>A: Valueof()<BR/><BR/>Del0 Delivers<BR/><BR/>Del1 Where are iBots stored ?<BR/>A: Presentaion services??? Not sure <BR/><BR/>Mkt0 Marketing<BR/><BR/>Mkt1 What is a QLI ?<BR/><BR/>A: No idea :)<BR/><BR/>Int0 Integration<BR/><BR/>Int1 What is an Action link used for?<BR/><BR/>A: No ideaBishwa Satpathyhttps://www.blogger.com/profile/07909427937524037984noreply@blogger.com