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
- 9095 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 | 2 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
is it possible to index the data in cache of lkp transformation ?
What are the differences between source qualifier and joiner transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are mapplets? How is it different from a Reusable Transformation?
Describe an informatica powercenter?
What are Dimensional table?
What is the status code in stored procedure transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to do the error handling of if ur source is flatfiles?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Under which circumstances, informatica server creates reject files?
How to load a Dimension ? and how to load a fact table?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
In informatics server which files are created during the session rums?
