Function of Multicast Transformation is:
distributes a row to single output and another to the other output
distributes its input to one or more outputs
join two inputs
extract data from a connection
Which of the following is not a Control Flow Element?
Containers
Tasks
Transformations
Precedence Constraints
ETL stands for
Export Transform Load
Extract Track Load
Extract Tool Load
Extract Transform Load
Variables can only be defined at scope of entire package.
True
False
How is a parent package variable value passed to child package?
by global variables
by setting package configurations in child package
by setting package configurations in parent package
by Execute Package task
Partition Primary Index would be defined in which stage of modeling?
Logical
Extended Logical
Physical
Extended Physical
Number of NULLs is considered a data demographic
Which two data demographics should you consider when deciding whether or not to store or calculate derived data? (Select 2)
Maximum Number of NULLs
Access Frequency
Change Rating
Typical Rows Per Value
Pick the two statements that are true regarding Identity Columns. (Select 2)
They don't have to be a Primary Index column
They are not allowed to be a Primary Index column.
They are required to be a Non-Unique Primary Index
You can only specify one Identity Column per table.
What is contained in a USI subtable? (Select 3)
The buckets containing the AMP numbers where the data is stored.
The USI column value
The Row ID of the base row.
The Secondary Index Row ID.
The Integer Type of all Value-Ordered NUSIs.