Interested to Buy Any Domain ? << Click Here >> for more details...
we r using aggregator with out using groupby?
- 7 Answers
- 22512 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 |
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
What is informatica? What exactly are the practical uses in real world
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
can we create index and drop index in exsisting table while using infomatica
What are the new features in Informatica 5.0?
what is the complex transformation you used in informatica
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Is there any model difference between ODS and DWH
Enterprise data warehouse your projects phase by phase explain?
what is unit testing?tell me proceedure
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
Teradata 
