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
- 8992 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 the size ur source like(file system or database)? how many record daily come u r banking project?
Separate from a database, an information bazaar, and an information stockroom?
How to join three sources using joiner? Explain though mapping flow.
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
what is the -ve test case in your project.
How to use pmcmd utility command?
EXL informatica Questions
What are the advantages of using informatica as an etl tool over teradata?
What is dynamic cache?
What is xml source qualifier transformation in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
Make a note of the quantity vaults made in informatica?
How can you validate all mappings in the repository simultaneously?
