Knowledge quiz

It's time to put what you've learned to the test, get 3 right to pass this unit.

1.

lookup_ext has more functionality than lookup.

Choose the correct answer.
2.

You load a new template table using a Query transform. Why would you use an aggregate function?

Choose the correct answer.
3.

what can you do with lookup functions that you cannot do with a join operation?

There are two correct answers.
4.

You must add a source of type Datastore in your data flow in order to use the SQL transform.

Choose the correct answer.