Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 8979 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
In Aggregator Transformation Create an output Port name TOTSAL, And in front of eno port check group by and in TOTSAL column use SUM(sal)
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
Explain the scenario which compels informatica server to reject files?
Could you explain what is enterprise data warehouse?
How many input parameters can exist in an unconnected lookup?
Explain about Informatica server process that how it works relates to mapping variables?
What do mean by local and global repository?
Why update strategy and union transformations are active? Explain with examples.
How to open an older version of an object in the workspace?
What are the restrictions of union transformation?
Explain incremental aggregation in informatica
Can we create multiple integration service on single repository?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
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
