Interested to Buy Any Domain ? << Click Here >> for more details...
we r using aggregator with out using groupby?
- 7 Answers
- 22267 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 |
how we do performence tuning in informatica
Can we override a native sql query within informatica?
wht is cdc?how to use it in creation of mappings?
How to use Normalizer transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
what is parameter file?
What are the prerequisite tasks to achieve the session partition?
can anyone explain me about retail domain project in informatica?
How can you define user defied event?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Teradata 
