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 / narendra
in source qulifier we override query like this
select eno,sum(sal as totsal)from emp group by eno
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
How are the sources and targets definitions imported in informatica designer?
What are the modules in Power Center
what is the size of u r source(like file or table)?
Enlist the differences between database and data warehouse.
What are mapplets?
What are the differences between joiner transformation and source qualifier transformation?
To import the flat file definition into the designer where should the flat file be placed?
How can repository reports be accessed without sql or other transformations?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is a filter transformation?
What is the Rank index port in Rank transformation?
What are the mapping parameters and mapping variables?
What is a repository? And how to add it in an informatica client?
Define pmcmd command?