if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
Answer Posted / chandra
After the source qulifier take Aggr t/r pass all the ports
to th Aggr t/r. group by eno & year.Add a new out put port
in this derive the logic as sum(sal) & pass to the Target
Def.
I think this would work.
Regards,
Chandra
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an expression transformation in informatica?
difference between repository database and repository service?
What is the difference between informatics 7x and 8x and what is latest version?
What is the status code in stored procedure transformation?
What are Dimensional table?
Explain the etl program with few examples.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Define update strategy?
What do you mean by filter transformation?
How do you migrate data from one environment to another?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How can you validate all mappings in the repository simultaneously?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the static cache and dynamic cache in informatica?
Write the prerequisite tasks to achieve the session partition?