Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7829 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
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Define joiner transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are some examples of informatica etl programs?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is meant by lookup transformation? Explain the types of lookup transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is an aggregator transformation?
Parameter and variable differences
What are the performance considerations when working with aggregator transformation?
generate date / time dimension in informatica
which one is better performance wise joiner or look up
How do you use reject loader.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is the commit type if you have a transaction control transformation in the mapping?
