Ab Initio ETL | Testing | Mock Test

1
__ is a optional part of a transform function that provides storage for temporary values
a. Transform function
b. Business rule
c. Variable
d. Statement
Show Answer

2
__ is a part of a transform function that describes how you manipulate one field of your output data
a. Transform function
b. Business rule
c. Variable
d. Rollup Component
Show Answer
3
__ is a set of rules that compute output values from input values
a. Transform function
b. Business rule
c. Variable
d. Database Exec
Show Answer
4
___ is used to support component parallelism
a. Replicate component
b. Sort Component
c. Dedup Component
d. Dynamic Parameter
Show Answer
5
______ file has the information required for Ab Initio to connect to the database to extract or load tables or views.
a. Database Configuration
b. Database Logon
c. Database Param
d. Partition By Percentage
Show Answer
6
______ is a Ab Initio Graph Parameter which need not be initialized with a value at the time of Declaration.
a. Initial Parameter
b. Local Parameter
c. Global Parameter
d. Left Outer Join
Show Answer
7
______ component partitions the records in Sequential Way.
a. Partition By Range
b. Partition By Round Robin
c. Partition By Key
d. Interleave
Show Answer
8
__allows you to set the record-required parameter for each port individually
a. Inner join
b. Outer join
c. Explicit
d. Interleave
Show Answer
9
__component collects inputs from multiple partitions in an arbitrary manner, and produces a single output flow, does not maintain sort order
a. Concatenate
b. Gather
c. Merge
d. Interleave
Show Answer
10
__component collects inputs from multiple sorted partitions and maintains the sort order
a. Concatenate
b. Gather
c. Merge
d. Interleave
Show Answer