i want to convert below src into target
src is as follows
maths 30
science 20
social 81
i want data in trg like below
maths science social
30 20 81
- 2 Answers
- 6798 Views
- HCL, HP, I also Faced
- E-Mail Answers
Answer Posted / vikram
You need to use
SQ> Agg > TGT
>>> In AGG Ports>>>
Subject
Marks
O_maths = max(marks, subject='maths')
0_science = max (marks, subject ='science')
O_Social= max (marks,subject='social')
>>>>TGT
O_maths -> Maths
O_Scie -> Science
O_Social -> Social
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Reusable transformation and shortcut differences
What is domain and gateway node?
Differentiate between sessions and batches?
where to store informatica rejected data? How to extract the informatica rejected data?
How would you join a node to the already existing domain?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the function of aggregator transformation?
what is INFORMATICA TESTING process
differences between service based and product based?
What is intricate mapping?
What are the different components of powercenter?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to convert multiple rows to single row (multiple columns) in informatica
Parameter and variable differences
How to load the data from people soft hrm to people soft erm using informatica?
