Informatica Set 8

Which of this is not a task that exist in workflow?

Session

Workflow

control

assign

Wat is :SP?

Required when you write an expression that includes the return value from an connected Look-Up transformation

Required when you write an expression that includes the return value from an unconnected Look-Up transformation

Required when you write an expression that includes the return value from an connected Stored Procedure transformation

Required when you write an expression that includes the return value from an unconnected Stored Procedure transformation

Which one is not a reserve word in informatica?

NOTSTARTED

STARTED

STOPPED

SUCCEEDED

KILLED

IIF( EMPLOYEE.NAME = 'Rex', 0, 3 )

What this expression says about?

If Employee name is Rex then update else delete

If Employee name is Rex then update else reject

If Employee name is Rex then insert else reject

If Employee name is Rex then update else insert

Which variable doesn't belongs to variable use in transaction control expression?

TC_COMMIT_BEFORE

TC_ROLLBACK_AFTER

TC_ROLLBACK_BEFORE

TC_COMMIT_AFTER

TC_CONTINUE_TRANSACTION

Which is not a date format string?

SS , SSSS

MM, MON, MONTH

HH, HH12, HH24

Which statements are correct?

DATE_DIFF. Subtract two dates

ADD_TO_DATE. Add or subtract a specific portion of a date

TO_DATE Change one part of a date to another date format

SET_DATE_PART. Change one part of a date

Which one is not a conversion function?

TO_MONTH

TO_DECIMAL

TO_NUMBER

TO_INTEGER

TO_DATE

Which one is not a numeric function?

TRUNC

CUME

ROUND AVG

Can you rename the repository object?

yes

Which are the connection names, those you can configure from work flow manager?

relational database connections

FTP connections

external loader connections

queue connections

source and target application connections

Integration Service suspends the workflow, if which one of these following tasks fail?

Session

Command

Worklet

All of these

Which task is used to stop, abort, or fail the top-level workflow or the parent workflow based on an input link condition?

command

control

timer

Waht is :SEQ?

Required when you create an expression that includes a port in a Sequence Generator transformation

Required when you create an Lookup that includes a port in a Sequence Generator transformation

Required when you create an Sql Transformation that includes a port in a Sequence Generator transformation

Required when you create an UN-connected lookup Transformation that includes a port in a Sequence Generator transformation

Which one is not date function?

ROUND

TO_DATE

TRUNC

ADD_TO_MONTH