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
- 7693 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many transformations can be used in mapplets.
what is SDLC way of code development?
On which transformations you created partitions in your project?
What is informatica?
Explain constraint based loading in informatica
Why do we need informatica?
Enlist some properties of sessions.
What do you understand by a term domain?
Explain the different lookup methods used in informatica?
Explain the types of transformations?
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
During the running session, output files are created by informatica server. Enlist few of them.
generate date / time dimension in informatica
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Did u used latest transformations of 8.6.0? for what?
