1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / prasad.gs19

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

select count(1) from emp? what is the o/p?

5 Answers   TCS,

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

What are connected or unconnected transformations?

0 Answers   Informatica,

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

How union transformation is used?

0 Answers  




following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

How to load a Dimension ? and how to load a fact table?

0 Answers  

Why filter transformation is an active one?

0 Answers  

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  

For more Informatica Interview Questions Click Here
Categories