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
- 9108 Views
- I also Faced
- E-Mail Answers
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
what is degenerated dimension?
Is stop and abort are same in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
What are the main issues while working with flat files as source and as targets ?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
list out all the transformations which use cache?
How do we call shell scripts from informatica?
Tell me about Propagate functions in informatica
Explain how many types of dimensions are available in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What does command task mean?
What is meant by active and passive transformation?
What is depict expression change?
What are the different options available for update strategy?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
