Transformation Functions

string literal, 'Joan's car', should be expressed how?

what are the 2 comment specifiers ?

What keywords in the transformation language are reserved
for specific functions.

What are the reserved for workflow expressions?

DD_DELETE

DD_INSERT

DD_REJECT

DD_UPDATE

FALSE

NULL

ANSI compliant result for NULL AND TRUE =

ANSI compliant result for NULL AND FALSE =

TRUE

what does this evaluate to: 8 * 10 - NULL

the PowerCenter Integration Service evaluates the
expression in what order?

Built-in Variables

$PM<SourceName>@TableName, $PM<TargetName>@TableName

$PMFolderName

$PMIntegrationServiceName

$PMMappingName

$PMSessionRunMode

$PMWorkflowRunId

$PMWorkflowRunInstanceName

SESSSTARTTIME

TC_CONTINUE_TRANSACTION

TC_COMMIT_BEFORE

TC_COMMIT_AFTER

TC_ROLLBACK_BEFORE

TC_ROLLBACK_AFTER

What is "J" and what does it do? (hint: date)

RR date format string, Current Year Between 0 and 49 and the source string
year is between 0 and 49 returns what?

RR date format string, Current Year Between 0 and 49 the source string year is between 50 and 99, what?

If the current year is between 50 and 99 (such as 1998) and the source
string year is between 0 and 49, what does the IS return?

If the current year is between 50 and 99 (such as 1998) AND the source string year is between 50 and 99, what does the IS return?

what function will produce different results when RR and YY are used?

default date format?

TO_CHAR

Format
String AM, A.M.,
PM, P.M.

Format String D

Format String DAY

Format string DD

Format string DDD

Format string DY

Format string HH, HH12

Format string HH24

Format string J

Format string MI

Format string MM

Format string MONTH

Format string MON

Format string MS

Format string NS

Format string Q

Format string RR

Format string SS

Format string SSSSS

Format string US

Format string Y

Format string YY

Format string YYY

Format string YYYY

Format string W

Format string WW

Format string - / . ; :

Format string “text”

Format string “”

TO_DATE

IS_DATE

AGGREGATE FUNCTIONS

Character Functions

Conversion Functions

Data Cleansing Functions

DATE FUNCTIONS

Encoding Functions

Financial Functions

Numeric Functions

Scientific Functions

Special Functions

String Functions

Test Functions

Variable Functions

ABORT

ABS

ADD_TO_DATE

AES_DECRYPT

AES_ENCRYPT

ASCII

AVG

CEIL

CHOOSE

CHR

CHRCODE

COMPRESS

CONCAT

CONVERT_BASE

COS

COSH

COUNT

CRC32

CUME

DATE_COMPARE

DATE_DIFF

DEC_BASE64

DECODE

DECOMPRESS

ENC_BASE64

ERROR

EXP

FIRST

FLOOR

FV

IS_DATE

IS_NUMBER

IS_SPACES

LAST

MAKE_DATE_TIME

MAX (DATES)

MAX (Numbers)

MAX (String)

MOVINGSUM

NPER