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
- 7022 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
How many ways a relational source definition can be updated and what are they?
Define the various join types of joiner transformation?
What happens when a session fails and you click on recover?
How would you join a node to the already existing domain?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is session task and command task?
What are the databases that informatica can connect to windows?
What is a repository? And how to add it in an informatica client?
In informatics server which files are created during the session rums?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is intricate mapping?
Partition, what happens if the specified key range is shorter and longer
To import the flat file definition into the designer where should the flat file be placed?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Suppose we do not group by on any ports of the aggregator what will be the output?
