Saturday, November 17, 2007

Interpreting expression

A user enters the following expression into an Expression transformation:( PRICE - COST ) QUANTITY. The Expression transformation is part of a mapping with a relational database source definition. Assuming that the expression is valid, when the mapping runs as part of a session, how will the Informatica server treat the above expression?

Choose Answer

(A)
It will interpret the expression directly.
(B)
It will embed the expression into the designated source code file for the session and then compile it so that it can be executed.
(C)
It will include the statement in the SQL select statement that will be submitted to the source database.
(D)
It will embed the expression into the primary session stored procedure script that will be executed on either the source database or another database that was specified by the user.