Which of the following is not true about pivot transformation?

Converts the unique values from one column in the expression into multiple columns in the output.
Converts the duplicate values from one column in the expression into multiple columns in the output.
Performs aggregations wherever required.
Used for normalization.
Verified Answer
Correct Option - b

To get all Infosys Certified Microsoft SSIS Advanced Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Telegram