Informatica Scenario Converting Rows into Columns:Best Two approaches explained

[@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...

[@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.
th-cam.com/video/6G1xGi-D5ow/w-d-xo.html

[@SudeshKumarPujari]

Thanks for the video

[@volakola9495]

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

[@TechCoach]

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

[@sauravips]

Very nicely explained

[@TechCoach]

Thanks a lot Saurabh for the kind words :)

[@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

[@shoubhikmukherjee5289]

Nice video.Thanks a lot.

[@eduruanudeep]

Very helpful ..thnx dude

[@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.

[@vishalmokashi3163]

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

[@umamaheswararaododdi395]

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

[@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.

[@TechCoach]

thanks a lot buddy

[@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 ?

[@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.

[@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.

[@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

[@suparnadas7801]

Thanks a lot!!

[@TechCoach]

Suparna Das You are welcome :)

[@ganeshbidgar3548]

Not understood, every step is not explained in detail