sqllearn

SIMPLE RANK FUNCTION: CREATE TABLE STUDENT   (     S_ID        NUMBER(10),     S_NAME      VARCHAR(30),     TAMIL_MARKS NUMBER(10),     ENGLISH_MARKS NUMBER(10),     MATHS_MARKS NUMBER(10),     SCIENCE_MARKS NUMBER(10),     S_SCIENCE_MARKS NUMBER(10)   );      INSERT INTO STUDENT VALUES(1,'PANDIAN',35,45,55,65,75);   INSERT INTO STUDENT VALUES(2,'MUTHU',37,47,57,67,77);   INSERT INTO STUDENT VALUES(3,'ASHOK',40,50,60,70,80);      INSERT INTO STUDENT VALUES(4,'KUMAR',33,43,53,63,73);   INSERT INTO STUDENT VALUES(5,'RANA',36,46,56,66,76);         SELECT * FROM STUDENT; 1 PANDIAN 35 45 55 65 75 2 MUTHU 37 47 57 67 77 3 ASHOK 40 50 60 70 80 4 KUMAR 33 43 53 63 73 5 RANA 36 46 56 66 76  SELECT S_NAME,TOTAL,R...

    Scenarios: ---1. Display the client names who do not have a fax number SELECT CLIENT_NAME FROM CLIENT_2 WHERE FAX IS NULL; --2. Display the clients that have more than one project SELECT CLIENT_ID,COUNT(PROJECT_ID) FROM ASSIGNMENT_2 GROUP BY CLIENT_ID HAVING COUNT(PROJECT_ID) >1; --3. Display the project titles and their expected durations in years for all the projects that are still not closed SELECT  TITLE FROM PROJECT_2 WHERE TO_CHAR(EXPECTED_END_DATE,'YYYY') = TO_CHAR(SYSDATE,'YYYY'); --4. Display the no of women resources from India SELECT COUNT(RES_ID) FROM RESOURCE_2 WHERE GENDER = 'FEMALE' AND COUNTRY ='INDIA'; --5. Display the resource name and no of projects under which they are working as on today SELECT  R.RES_NAME,COUNT(A.PROJECT_ID) FROM ASSIGNMENT_2 A,RESOURCE_2 R,PROJECT_2 P WHERE R.RES_ID = A.RES_ID AND P.PROJECT_ID = A.PROJECT_ID AND A.ASSIGNED_DATE  BETWEEN P.START_DATE AND SYSDATE GR...

INFORMATICA Informatica Corporation   is a   software   development company founded in 1993 Informatica's product is a portfolio focused on   data integration :   ETL ,   information lifecycle management ,   B2B   data exchange ,   cloud data   integration,   complex event processing , data masking data replication ,   data virtualization ,   master data management, ultra messaging.  These components form a toolset for establishing and maintaining enterprise-wide   data warehouses . It has a customer base of over 5,000 companies Informatica ETL product, known as Informatica Power Center consists of 3 main components. Informatica Power Center Client Tools: These are the development tools installed at developer end. These tools enable a developer to 1.      Define transformation process, known as mapping. (Designer) 2. ...

List of the most popular ETL tools:   Informatica - Power Center IBM - Websphere DataStage(Formerly known as Ascential  DataStage ) SAP - BusinessObjects  Data Integrator IBM - Cognos Data Manager (Formerly known as Cognos DecisionStream) Microsoft -  SQL Server  Integration Services Oracle - Data Integrator (Formerly known as Sunopsis Data Conductor) SAS - Data  Integration Studio Oracle - Warehouse Builder AB Initio Information Builders  - Data Migrator Pentaho - Pentaho Data Integration Embarcadero Technologies - DT/Studio IKAN - ETL4ALL IBM - DB2 Warehouse Edition Pervasive - Data Integrator ETL Solutions Ltd. - Transformation Manager Group 1 Software (Sagent) - DataFlow Sybase - Data Integrated Suite ETL Talend - Talend Open Studio Expressor Software - Expressor Semantic Data Integration System Elixir - Elixir Repertoire OpenSys – CloverETL