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

[@AnandRajakrishnan]

Very nice video. It explained both the methods of transposing rows to columns using simple examples. Thanks.

[@vijaypalmanit]

I think subject should be "Converting multiple Rows to one Row", because its just opposite to Normalizer and there we were "Converting Row to Multiple Rows". this will not create any confusion and anyone can easily remember what needs to be done in which case...

[@shoubhikmukherjee5289]

Nice video.Thanks a lot.

[@eduruanudeep]

Very helpful ..thnx dude

[@SudeshKumarPujari]

Thanks for the video

[@TechCoach]

thanks a lot buddy

[@Raghavender9010]

Thanks for this content...

[@TechCoach]

Thanks Raghavender for the kind words. Please consider subscribing to my other channel as well. It will really help me. kzbin.info/www/bejne/bHiUqXqfYqlopdk

[@suparnadas7801]

Thanks a lot!!

[@TechCoach]

Suparna Das You are welcome :)

[@sauravips]

Very nicely explained

[@TechCoach]

Thanks a lot Saurabh for the kind words :)

[@TheLitu89]

I have teams called A1,A2,A3,A4. Lets say this is static table with one column. they need to play with each other. But I don't need a duplicate .i.e. A1 vs A2 or A2 vs A1 is same. I want only one of them.

[@WisdomWomenWarrior]

can u pls include a scenario for pyramid triangle data like A-->a,B-->bb,C-->ccc,D-->dddd,E-->eeeee pls explain the logic to execute this one .not by using normaliser pls

[@umamaheswararaododdi395]

Hi Mohsin, This query won't work on Oracle 9 and 10g

[@maryam4071]

Thank for the video, how we need to change solution if we want to add dynamically the columns, imagine subject will be added during time.. how this wil be happened?

[@TechCoach]

Hi Maryam, Can you elaborate a little more I couldn't understand completely.

[@8694vicky]

Hi Vivek thanks for the all your videos. i have query why i am getting null values after pivot in oracle developer? i have done exactly the same.

[@TechCoach]

Can you please share your code and data ?

[@karthikboda3331]

your table might have identity column

[@surbhiagrawal3951]

I am also facing the same problem , my two subject columns maths and english are coming null and only one subject has its input values..What changes do I need to make

[@volakola9495]

how complex logic implemnetion goes into developement ? is it very hard ?

[@TechCoach]

No it is not , will post a video on it soon

[@vishalmokashi3163]

IF WE WANT TO SUM OF THIS SCORE THEN HOW WE PIVOT

[@MansiNarvankarPatkar]

Hi, can this be achieved using Java Transformation ? We have requirement in our project.

[@vivekgoel5396]

Can you please share your requirement

[@MansiNarvankarPatkar]

The above exact scenario...how can it be acheived using java tranformation?

[@vikrantmukkawar9737]

Did you find the solution for this using java transformation ?

[@namdevgaribe9541]

how can we load multiple files having different structures by using one source qualifier into one target?

[@TechCoach]

Take a delimiter other than the dtaa present in the file, the entire line will be then treated as a single column no matter how many columns it has . It should do th job for you

[@namdevgaribe9541]

@@TechCoach I got it thanks a lot. I watched every video it is very helpful once again thanks.

[@namdevgaribe9541]

@@TechCoach but I have multiple files then how can integration service read data from other files.

[@mohsinazim6322]

Hi Vivek, I have a table with columns email and salary. I am using pivot query but its not working. select * from emp_s6 pivot (sum(salary) for email in ('Steven','Neena','Lex','SKING','NKOCHHAR','LDEHAAN')); can you please tell me whats wrong with this query.

[@TechCoach]

can you please post your employee table as well.

[@ganeshbidgar3548]

Not understood, every step is not explained in detail