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 metadata?
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
Is it possible to use a client with different version than that of its Informatica server?
Explain dynamic target flat file name generation in informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Where is metadata stored?
Two Default User groups created in the repository are ____ and ______
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
Explain target update override in informatica
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
What is the benefit of partitioning a session?
what is the method of error handling when session is running?