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
- 8828 Views
- I also Faced
- E-Mail Answers
Answer Posted / suresh reddy
select eno,sal,sal+sal as totsal from ex GROUP BY sno,sal;
will give the output same as above
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Parameter and variable differences
Explain pmcmd command usage in informatica
What is rank transformation in informatica
What is the reusable transformation?
How can we use mapping variables in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the new features of informatica 9.x developer?
Why sorter is an active transformation?
How you can differentiate between connected lookup and unconnected lookup?
Under what condition selecting sorted input in aggregator may fail the session?
How does a sorter cache works?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
