Informatica Set 13

What will o/p of this expression . 8 * 10 - NULL

null

What is the return value of 'alpha' || NULL ?

alphanull

null

alpha

false

Which variable sets the current value of a mapping variable to a value you specifyand returns the specified value?

SETVARIABLE

Function Syntax Description
SETCOUNTVARIABLE

Function Syntax Description
SETCOURENTVARIABLE

NON OF THESE

Which variable counts the rows evaluated by the function and increments the current value of a mapping based on the count?

SETMINVARIABLE

SETVARIABLE

SETCOUNTVARIABLE

NON OF THESE

Which one is not an option in update-strategy?

Truncate table

Update as Insert

Update as Update

Update as Delete

What is the meaning of Update as Update?

Update each row flagged for update if it is not exists in the target table.

Update each row flagged for update if it exists in the target table.

Update each row flagged for update if it is new in the target table.

Non of these

What is meaning of Update as Insert in update-strategy?

Update each row flagged for update if it exists in the target table.

Inset each row flagged for update.

Update the row if it exists. Otherwise, insert it.

Non of these

What is meaning of Update as update else Insertin update-strategy?

Update each row flagged for update if it exists in the target table

Inset each row flagged for update

Update the row if it exists. Otherwise, insert it

All of these

Which function Causes the Integration Service to skip a record and issue the specified error message?

ERROR

ABORT

SKIP

ERR

ROUND( 112.5676, 3 ). What will output of this expression?

112

.567

112.568

112.6

What is Trunkcate Table option in update-strategy?

truncate the target table before loading data.

load the table value to another table

delete the data of target which can roll back

non of these

What will o/p of this statement REPLACECHR ( 1, 'Informatica[Scenarios"]', ']["', NULL ) ?

[InformaticaScenarios]

"[InformaticaScenarios]"

"[Informatica[Scenarios"]"

InformaticaScenarios

What will return value of this expression REPLACECHR ( 1, 'RAR", 'R', 'M' )?

true

false

RAM

MAR

ROUND( 10567.90, -2 ). What is the oot put of this ststement?

10567

567.90

10500

.90