Physical machines on which PowerCenter services are installed

Logical ETL environment

ETL and metadata services

House keeping the ETL environment

Mapplets

Sessions

Transformations

Workflows

True

False

Source Analyzer

Target Designer

Workflow Monitor

Mapplet Designer

Transformation Developer

Source Analyzer

Target Designer

Mapping Designer

True

False

True

False

Source/Table Name

Database Name

Source/Table Structure

All of the above

Import from database

By draging a target defination

By using create option in Sources tag

All of the above

SELECT

GET

OPEN

EXTRACT

SAVE

MODIFY

UPDATE

SAVE AS

ADD RECORD

ADD NEW

INSERT

INSERT NEW

SELECT [all] FROM Persons ;

SELECT *. FROM Persons ;

SELECT *.Persons ;

SELECT * FROM Persons ;

SELECT [all] FROM Persons WHERE FirstName='Peter' ;

SELECT * FROM Persons WHERE FirstName='Peter' ;

SELECT * FROM Persons WHERE FirstName LIKE 'Peter' ;

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter' ;

SELECT * FROM Persons WHERE FirstName LIKE '%a';

SELECT * FROM Persons WHERE FirstName='a' ;

SELECT * FROM Persons WHERE FirstName LIKE 'a%' ;

SELECT * FROM Persons WHERE FirstName='%a%;

ORDER

SORT

SORT BY

ORDER BY

SELECT * FROM Persons SORT 'FirstName' DESC ;

SELECT * FROM Persons ORDER BY FirstName DESC;

SELECT * FROM Persons ORDER FirstName DESC ;

SELECT * FROM Persons SORT BY 'FirstName' DESC ;

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen';

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen ;

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen' ;

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen' ;

DELETE FROM Persons WHERE FirstName = 'Peter' ;

DELETE FirstName='Peter' FROM Persons;

DELETE ROW FirstName='Peter' FROM Persons ;

TRUNCATE FROM Persons WHERE FirstName='Peter'

SELECT COLUMNS(*) FROM Persons ;

SELECT COUNT() FROM Persons;

SELECT COUNT(*) FROM Persons;

SELECT COLUMNS() FROM Persons;