Informatica Scenario Converting Rows into Columns:Best Two approaches explained

Описание к видео Informatica Scenario Converting Rows into Columns:Best Two approaches explained

The Video Demonstrates a scenario where the Source contains the scores of three students in three subjects in below format.
ID Name Subject Score
100 Vivek Science 50
100 Vivek Maths 50
100 Vivek English 70
200 Amit Maths 80
300 Ankit Maths 40
200 Amit Science 70
300 Ankit Science 80
200 Amit English 60
300 Ankit English 60
It explains how we can display the scores of students in cross tabular format using pivot in Source qualifier query or using expression and aggregator in case if source is flat file
#InformaticaPowercenter #Informaticatutorials #Techcoach

Комментарии

Информация по комментариям в разработке

Похожие видео