Interested to Buy Any Domain ? << Click Here >> for more details...
we r using aggregator with out using groupby?
- 7 Answers
- 21966 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 no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
How can informatica be used for an organization?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Differentiate between joiner and lookup transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
can you use flat file for lookup table?why?
What is joiner transformation?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
Teradata 
