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
- 7795 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
What is option by which we can run all the sessions in a batch simultaneously?
What is the benefit of session partitioning?
How to call shell scripts from informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How identifying bottlenecks in various components of informatica and resolving them?
Under which circumstances, informatica server creates reject files?
What do you understand by SOA of Informatica?
What are the types of schemas we have in data warehouse.
What is resilience time?
difference between informatica 8.1.1 and 8.6
What is a grid in Informatica?
What is a connected transformation?
What is the use of transformation?
Is there any target staging area in informatica not staging area
What is rank transform?
