Datawarehouse Architect

AVG (Average) It calculates the average value of an expression in a result. It must take a numeric expression as its argument. It denotes the mean value of expression. The denominator of AVG is the number of rows aggregated. For this reason, it is usually a mistake to use AVG(x) in a calculation in Oracle Business Intelligence. Instead, write the expression manually so that you can control both the numerator and denominator (x/y). Syntax AVG ( numExpr ) Here numExpr is any expression that evaluates to a numeric value. Look Before using AVG function, only with actual value. AVERAGE FUNCTION IN OBIEE 11g Use the AVG function to calculate the Actual Sum values. Formula used: AVG (“W_DAILY_REV_DFT_F”.”Actual Sum”)  Actual Sum is the measure column AVERAGE FUNCTION IN OBIEE 11g Check the results, the new calculated AVG Column will calculated automatically and display th...

Action link which is used to make link from the analysis/Dashboard to other URL of Web Pages. Actions provide functionality to navigate to BI Contents, including actions in analyses, dashboard pages, agents, scorecard objectives, scorecard initiatives, and KPIs. Actions can be executed Explicitly by end users who click action links that are embedded within, Analyses on column headings, column values, and hierarchy level values and in certain views, such as graphs, Dashboard pages, Content delivered by agents, Scorecards in Cause & Effect Maps, Custom Views, Strategy Tree Views, Strategy Maps, KPIs, and KPI watch lists, KPI analyses Action Links consists of two methods - dashboard and columns in analysis methods. Dashboard Action Link While on editing the dashboard in the left side pane we have the option “Action Link” you can drag and drop for available in answers side. Action Links in OBIEE 11g Analysis Action Link Under analysis for each...

Recently I have uninstall OBIEE 11g for a client requirement. I have attached screen shot for referring un-installation of obiee 11g.. Just follow the below step as it is. uninstall obiee 11g uninstall OBIEE 11g uninstall OBIEE 11g uninstall OBIEE 11g uninstall OBIEE 11g uninstall OBIEE 11g

I have attended Informatica interview last week in wipro and couple of other companies, Question below I faced in those companies. 1. What are the main issues while working with flat files as source and as targets ? 2. Explain about Informatica server process that how it works relates to mapping variables? 3. write a query to retrieve the latest records from the table sorted by version(scd) 4. How do you handle two sessions in Informatica 5. which one is better performance wise joiner or look up 6. How to partition the Session? 7. How many types of sessions are there in informatica.please explain them. 8. Explain the pipeline partition with real time example? 9. Explain about cumulative Sum or moving sum? 10. CONVERT MULTIPLE ROWS TO SINGLE ROW (MULTIPLE COLUMNS) IN INFORMATICA 11. DEPLOYMENT GROUPS IN INFORMATICA 12. LOAD LAST N RECORDS OF FILE INTO TARGET TABLE - INFORMATICA 13. LOAD ALTERNATIVE RECORDS / ROWS INTO...