Informatica Set 7

Which of of these workflow task, represents the location of a user-defined event?

Event-Raise

Event-Wait

User_event

Decision

Which one is not a vallid constant expression?

ERROR ('Null not allowed')

ABORT('Null not allowed')

SYSDATE

AVG(IN_SALARY)

Can you reverting to original reusable transformation?

yes

Which transformation enables you to connect to an HTTP server to use its services and applications?

ftp

http

custom

java

Which function convert dates to a specific year, month, day, hour, or minute?

to_date

to_char

trunc

non of these

Which one is not a character function?

CHRCODE

LENGTH

lower

All are char functions

Which one is not date function?

ROUND

TO_DATE

TRUNC

ADD_TO_MONTH

Which one is not a data cleansing function?

IS_DATE

To_date

REG_MATCH

LENGTH

The transformation language provides two comment specifiers to let you insert comments in expressions. Which are two ways among these?

/* write here*/

/ write here/

// write here

--write here

Which one of these is not a built-in constant?

Null

True

dd_delete

ltrim

false

Which one is not a comparison operator?

Which statements are true?

NULL AND TRUE = NULL

NULL AND FALSE = FALSE

NULL AND TRUE = FALSE

NULL AND FALSE = NULL

Can sorter transformation be passive?

yes

What is :EXT?

Required when you write an expression that includes a return value from an Expression transformation

Required when you write an expression that includes a return value from an External
Procedure transformation

Required when you write an expression that includes a return value from an look up Procedure transformation

Required when you write an expression that includes a return value from an Agrigator Procedure transformation

Waht is :LKP?

Required when you create an expression that includes the return value from an unconnected Lookup transformation.

Required when you create an expression that includes the return value from an Connected Lookup transformation.

Required when you create an expression that includes the return value from an unconnected Sp transformation.

includes the return value from an connected Sp transformation.