Skip to main content

Posts

Showing posts from 2015

ODI Practice Database Source and target schema's creation

DROP USER SDEV CASCADE; DROP USER STEST CASCADE; DROP USER SPROD CASCADE; DROP USER TDEV CASCADE; DROP USER TTEST CASCADE; DROP USER TPROD CASCADE; CREATE USER SDEV IDENTIFIED by welcome; CREATE USER STEST IDENTIFIED BY welcome; CREATE USER SPROD IDENTIFIED BY welcome; GRANT ALL PRIVILEGES TO SDEV,STEST,SPROD; CREATE USER TDEV IDENTIFIED by welcome; CREATE USER TTEST IDENTIFIED BY welcome; CREATE USER TPROD IDENTIFIED BY welcome; GRANT ALL PRIVILEGES TO TDEV,TTEST,TPROD; CREATE TABLE SDEV.BONUS         (ENAME VARCHAR2(10),          JOB   VARCHAR2(9),          SAL   NUMBER,          COMM  NUMBER); CREATE TABLE SDEV.EMP        (EMPNO NUMBER(4) NOT NULL,         ENAME VARCHAR2(10),         J...

SQL Common Interview Questions

1 ) Write a Query To Delete The Repeted Rows from emp table; SQL>Delete from emp where rowid not in(select min(rowid)from emp group by ename)                 2) TO DISPLAY 5 TO 7 ROWS FROM A TABLE SQL>select ename from emp          where rowid in(select rowid from emp where rownum<=7          minus   select rowid from empi where rownum<5) 3)  DISPLAY  TOP N ROWS FROM TABLE? SQL>SELECT * FROM                 (SELECT *  FROM EMP ORDER BY ENAME DESC)                  WHERE ROWNUM <10; 4) DISPLAY   TOP 3 SALARIES FROM EMP; SQL>SELECT SAL FROM ( SELECT...

Data Warehousing Concepts

Logical vs. Physical  The logical design is more conceptual and abstract than the physical design. In the  logical   design ,  you look at the logical relationships among the objects. In the  physical   design , you look at the most effective way of storing and retrieving the objects. Your design should be oriented toward the needs of the end users. End users typically want to perform analysis and look at aggregated data, rather than at individual transactions. Your design is driven primarily by end-user utility, but the end users may not know what they need until they see it. A well-planned design allows for growth and changes as the needs of users change and evolve. Type of Data Modeling? 1) Conceptual Data Model 2) Logical Data Model 3) Physical Data Model Conceptual Data Model - Design Step 1 This is First step for DWH Designing. Conceptual Data Model is the first step in Data Warehouse design. In conceptual data model, v...