Ab Initio ETL Testing Questions and Answers

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

Answer : Variable

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
Answer : Business rule

3
__ is a set of rules that compute output values from input values
a. Transform function
b. Business rule
c. Variable
d. Database Exec
Answer : Transform function

4
___ is used to support component parallelism
a. Replicate component
b. Sort Component
c. Dedup Component
d. Dynamic Parameter
Answer : Replicate component

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
Answer : Database Configuration

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
Answer : Global Parameter

7
______ component partitions the records in Sequential Way.
a. Partition By Range
b. Partition By Round Robin
c. Partition By Key
d. Interleave
Answer : Partition By Round Robin

8
__allows you to set the record-required parameter for each port individually
a. Inner join
b. Outer join
c. Explicit
d. Interleave
Answer : Explicit

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
Answer : Gather

10
__component collects inputs from multiple sorted partitions and maintains the sort order
a. Concatenate
b. Gather
c. Merge
d. Interleave
Answer : Merge