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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amedela chandra sekhar
Use Normalizer t/r, it convert column into rows,row into
columns.
Is This Answer Correct ? | 2 Yes | 11 No |
what is the size of u r project? and what is the size of source file?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
What is workflow monitor?
how can u tune u r informatica mapppings
Explain informatica architecture - version 8 / 9
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
How to create or import flat file definition in to the warehouse designer?
Differentiate between mapping parameter and mapping variable?
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
what are the unix commands to start the wrk flow ?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
how to design mapping half of source table records into one target and remaining half into another target