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
- 10671 Views
- Magna Infotech, I also Faced
- E-Mail Answers
Answer Posted / sachin
use an aggregrator where you need to check the group by
port as emp id, ename and year.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
what is the difference between informatica6.1 and infomatica7.1
How to generate or load values in to the target table based on a column value using informatica etl tool.
How do you load only null records into target? Explain through mapping flow.
What is lookup transformation?
How we can create indexes after completing the loan process?
What are the restrictions of union transformation?
Differentiate between sessions and batches?
What is the use of code page?
Separate from a database, an information bazaar, and an information stockroom?
How can a transformation be made reusable?
explain about unit testing? in real time?
What is a connected transformation?
How to elaborate tracing level?
How are indexes created after completing the load process?
Can we create a Integration service without a Repository service and vice versa?
