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
- 7910 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
Explain in detail about scd type 1 through mapping.
What is workflow monitor?
waht type of interface is used for testing the data in informatica
How do you load alternate records into different tables through mapping flow?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is the session task and command task?
Is there any way to read the ms excel datas directly into informatica?
What do you mean by filter transformation?
What is a repository? And how to add it in an informatica client?
What is the difference between stop and abort in informatica
Write the program through which the records can be updated?
What is an expression transformation in informatica?
what is song in infrmatica...?
Where can we find the throughput option in informatica?
Explain how many types of dimensions are available in informatica?
