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

Answers were Sorted based on User's Feedback



if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20..

Answer / 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

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20..

Answer / chandra

After the source qulifier take Aggr t/r pass all the ports
to th Aggr t/r. group by eno & year.Add a new out put port
in this derive the logic as sum(sal) & pass to the Target
Def.


I think this would work.

Regards,
Chandra

Is This Answer Correct ?    1 Yes 0 No

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20..

Answer / narendra

in source qulifier we override query like this

select eno,sum(sal as totsal)from emp group by eno

Is This Answer Correct ?    2 Yes 1 No

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20..

Answer / ankit kansal

In Aggregator Transformation Create an output Port name TOTSAL, And in front of eno port check group by and in TOTSAL column use SUM(sal)


http://deepinopensource.blogspot.in/

Is This Answer Correct ?    1 Yes 0 No

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20..

Answer / lakshmi

Use aggrigator transformation group by port as eno

Is This Answer Correct ?    1 Yes 3 No

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20..

Answer / 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

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20..

Answer / 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

More Informatica Interview Questions

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,


What is olap (on-line analytical processing?

0 Answers  


Difference between session variables and workflow variables?

2 Answers   Informatica,






Explain sessions and how many types of sessions are there?

0 Answers  


plz plz plz send client names and project names in informatica?

1 Answers  


what is hash table in informatica?

1 Answers   Zensar,


I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  


What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,


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,

0 Answers   HCL,


can we override a native sql query within informatica? How do we do it?

0 Answers  


Categories