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
- 2 Answers
- 5907 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumarvijay
If your source is file then use agrregator with aggregation
on year,emp_id have port with sum(sal).
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
Is it possible to use a client with different version than that of its Informatica server?
What are the types of schemas we have in data warehouse.
Informatica Checkpoints
What are mapplets?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain dynamic target flat file name generation in informatica
What is incremental aggregation?
Can we create a Integration service without a Repository service and vice versa?
What is informatica etl tool?
What are the different lookup cache(s)?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
wf dont have integration severances how you can run?
What is intricate mapping?
Whats there in global repository
