We are having 4 subjects highest marks we find and subject name also
For this we are using normailizer
Source Flat file
We are having 4 subjects and the occurance we have to give 4 for marks.
Gcid and Gkid automatically created
Here we got all the marks
Gk id generates sequential numbers
Gc id creats column level
1,2,3,4,
Like the data distributed
Now I want higest marks for a student in all subjects what we do?
Now we use which transformation i.e rank
Here we are not getting all student details why
We have to give group by in rank
Here we are getting highest subject marks but we are not getting subject name for this we Expression transformation.
Like this we will get highest marks in a subject by using rank
Pls subscribe and like thankyou……..
informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview videos,informatica interview,informatica admin interview questions,informatica interview tips,informatica interview questions and answers,informatica powercenter interview questions,technical interview questions,informatica questions,informatica training,informatica answers,informatica powercenter,informatica tutorial
informatica intelligent cloud services, iics informatica tutorial, iics to cloud data base connection, iics data integration tutorial, iics cloud data integration services, iics training informatica, iics tutorial for beginners, iics informatica tutorial telugu, iics informatica, iics informatica interview questions, iics informatica resume, iics informatica training, iics data integration, iics data integration interview questions, what is informatica iics, iics login issue, informatica intelligent cloud services, iics, iics Informatica Cloud secure agent,