Interested to Buy Any Domain ? << Click Here >> for more details...
we r using aggregator with out using groupby?
- 7 Answers
- 22015 Views
- HSBC, Principal Finance, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
If we use Aggregator without using group by option we will
get only one row from source. It is a default charater of
Informatica.
e.g If there are 20 rows in the source table and only
using SQ and followed by Aggregator then target table then
the target table will be populated by the last row coming
from teh source table.
| Is This Answer Correct ? | 47 Yes | 3 No |
Answer / amedela chandra sekhar
If you are using groupby the integration service produces
one row for each group, if you do not use groupby the
integration service returns one row(last row) for all input
rows.
chandumba2005@gmail.com
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / srikanth nallapati
if we are not using group by also u get the result from agg
traceformation but u get only one one total column result
Ex:deptno sal
10 1000
20 3000
30 4000
10 5000
in aggr trance i am not use group by but i create one new
column like sum_of_sal here logic implementation is sum(sal)
this sum sal is linked with target table then u get result
as like above description.... if u try to send more then
one column from this aggre tranc means it's fail..
i think it's work....
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / public
understand question
why we r using aggregator with out using groupby?
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / naresharavetis
if u use aggregator t/r without using group by function u
get one summirized result but group by option allows u get
deatil result.
for example .without using groupby u want see a releince
store sales .u will get sales of whole store but when uuse
group by u get imtemized sales result
storecode itemname sales
101 vegetable 500
101 vegetables 700
101 electronics 5000
101 electronics 10000
101 cooldrinks 200
101 cooldrinks 500
result without groupby: store sales:17400
result with groupby: vegetables sales :1200
electronics sales: 15000
cooldrinks sales: 700
| Is This Answer Correct ? | 4 Yes | 19 No |
Answer / neeraj
By default aggregator does group by on each of the input
port so if 50 distinct rows are coming all will pass
through it..
| Is This Answer Correct ? | 3 Yes | 23 No |
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the difference Between Mapping parameter and variable
How many ways a relational source definition can be updated and what are they?
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
Explain direct and indirect flat file loading (source file type) - informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
when informatica 8 series released ?
What are the tuning techniques you applied during your last project
What is the Difference between SetVariable and setmaxvariable in informatica?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
Teradata 
