Chapter 45 Flashcards
1
Q
Why we do transformation before profiling
A
If SQL package encounter error, it rolls back all transactions
2
Q
Why 100% correction is not possible in data
A
Because of errors in golden copy
3
Q
What is Copy Column transformation
A
The Copy Column transformation creates new columns by copying input columns and adding the new columns to the transformation output.
4
Q
How we apply transformations
A
Through package