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 / sujana
@above
wer do we calculate sum here..i think v shud create an o/p
port 4 sum.(sum sal) and grpby eno
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
permutations of mapplet
What are the types of schemas we have in data warehouse.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is xml source qualifier transformation in informatica?
What are the tasks that source qualifier perform?
What are the tasks that can be performed using sq?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Which transformation is needed while using the Cobol sources as source definitions?
What's the layout of parameter file (what does a parameter file contain?)?
Different circumstance which drives informatica server to expel records?
What is a grid in Informatica?
What is pmcmd command?
How to generate sequence numbers using expression transformation?
tell me the rules and responsblites in our project(my project is development)
What is domain in terms of informatica?