Interested to Buy Any Domain ? << Click Here >> for more details...
Scenario is like this:
Name Sal
A 10;
B 20;
C 30;
Then Output should be
Name Sal
A 10;
B 20;
C 30;
Total 60;
Use SQL For this scenario
- 4 Answers
- 7706 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / niru
select name,salary from emp
union
select "total",sum(sal) from emp
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / kiran
SQL> select ename,sal from emp union select 'total:',sum(sal) from emp;
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / situ
first create a table emp4 using the above data then execute the below query to find that output
select case when grouping(name)=1 then 'Total'else name end as name,sum(sal) as sal from emp4 group by rollup(name);
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pooja
Select case when GROUPING(e.Name)= 1
then'Total'else e.Name end as Name,
sum(e.Salary)as Salary from Emp e
group by e.Name with rollup
| Is This Answer Correct ? | 0 Yes | 0 No |
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is meant by incremental aggregation?
If I am having 6 flat files in data. How can you load the data at a time
what is scd?
How can you generate reports in informatica?
Why filter transformation is an active one?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
how to duplicates from expression transformation without using sorter before that
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
What is a unit Testing?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
How are the sources and targets definitions imported in informatica designer?
Teradata 
