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
- 7696 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 are Dimensional table?
What is the difference between a repository server and a powerhouse?
What is sq transformation?
Clarify the aggregator change?
How to extract the informatica rejected data?
can you please explain me pre session and post session options?
Define mapplet?
What are batches?
draw informatica architecture 8.6 ?
How does a sorter cache works?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the fact table?
What is Data Caches size?
Explain about Informatica server process that how it works relates to mapping variables?
can anyone explain me about retail domain project in informatica?
