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 / lakshmi
Use aggrigator transformation group by port as eno
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How to generate or load values in to the target table based on a column value using informatica etl tool.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is SDLC way of code development?
EXL informatica Questions
Make a note of the quantity vaults made in informatica?
Explain lookup transformation in informatica
Explain pushdown optimization and types in informatica
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
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is index?how it can work in informatica
What is an expression transformation in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain the types of transformations?