Informatica Scenario Convert single row to multiple rows:Normalizer Transformation/(Unpivot)

The Video Demonstrates the following scenario using various approaches including normalizer and unpivot and explains why we should choose our approach wisely while implementing .
SOURCE
COL1 COL2 COL3
A B C
P Q R
TARGET
COL
A
B
C
P
Q
R
#InformaticaPowercenter #Informaticatutorials #Techcoach

[@hemanthuvaraj]

Thanks for the videos, in the 2nd approach we can use union transformation after expression to avoid multiple target definition.

[@mohsinazim6322]

good explanation . thanks

[@karun12341]

Thank you for your time and effort to explain in different ways.

[@TechCoach]

Thanks a lot Sudhakar for the kind words :)

[@sidharth7860]

Thank you Vivek for detail explanation. I like the way you explain through different scenarios

[@TechCoach]

Thanks a lot for the kind words, I have a small request I am working on this new youtube channel " An Indian Abroad " and will really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/Z2KnfGClrrekopI

[@RameshBabu-ey7kc]

Good Explanation.

[@noopurgoel1401]

Great Explanation... Thanks

[@TechCoach]

Thanks a lot for the kind words Noopur. I have a small request, I am working on this new channel and will really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/f4GVh6Fsn7Brfsk

[@alingareddy4150]

Awesome explanation thank you

[@TechCoach]

Thanks for the kind words. I am working on this new channel and would really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/f4GVh6Fsn7Brfsk

[@Patriot_0071]

Good one.. Thanks

[@kishorenb9866]

For what purpose you connected expression transformtion in normalizer transformation approach.

[@prashanththokala3424]

Hi, What is the use of Level in Normaliser

[@shobanavaishnavi5936]

good one ..thank u.. how to add dynamic colums from source flat file in generic way to automate it especially WRT scenrio3... quick sol?

[@TechCoach]

Can you explain it a lil more ? I will be happy to create a video for the same.

[@nanyabusiness401]

your typing sound is louder than your voice

[@TechCoach]

I am sorry prachi, some of my earlier videos had this issue. I have taken care of this in my recent videos.