Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table like
empid ename year month sal
1 x 98 jan 500
1 x 98 feb 500
1 x 98 mar 500
1 x 99 jan 600
1 x 99 feb 600
2 y 98 jan 600
2 y 98 feb 600
2 y 98 mar 600
2 y 99 jan 700
2 y 99 jan 700
and so on
i want to find out totsal for every emp on year wise
plz help me
- 4 Answers
- 10706 Views
- Magna Infotech, I also Faced
- E-Mail Answers
Answer Posted / vikneswaran
use agg trans group by empid and year then use sum(sal)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is Cognos script editor?
What is a dimensional model?
Explain dynamic target flat file name generation in informatica
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
can u any challenge your project?
Can we get 1st record through Informatica(without sequence number).
What is a standalone command task?
What are the static cache and dynamic cache in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is a router transformation?
What is Index Caches size?
What is the command used to run a batch?
Mention a few design and development best practices for informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
