Interested to Buy Any Domain ? << Click Here >> for more details...
If we are using an aggregator but forget to mention the
group by port .what will be the output??
- 11 Answers
- 33818 Views
- Nomura, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
No group by Port-
The AggTrans wil check for group by Column port up to last
column. No group by port was find,The AggTrans wil return
the last row only.
Every Column row wil check for Group by port done or not,
up to last row.
Finally (By default) last row will return.
Last Row still waiting for Group by port.,,,,
Thats why Group by prot is must.
Any Corrections,,,,,srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 57 Yes | 4 No |
Answer / kt
If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat row of the table to the next
trnasformation.
| Is This Answer Correct ? | 50 Yes | 1 No |
Answer / sheelendra
I agree with Srinu.
and It will return only one aggregated value for all input.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / g. manthiramoorthy
If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat
row of the table to the next transformation
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / g. manthiramoorthy
If we miss to enable any of the port as GROUP BY,
the aggregator will write the last row of the table to the
next transformation
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / vikneswaran
output is single record.for examples
col1
1
1
1
2
2
2
3
3
4
if i use group by and sum(col1) ...
output
col1
3
6
6
4
if i didn't use group by but same agg function
output
col1
19
| Is This Answer Correct ? | 10 Yes | 7 No |
Answer / uppala chary
first of all group by port G is mandatory ,if u don't
enable the group by port it wiil returns last record,and
enable the group by port it will return all the records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / cooldude
It will behave like a passive transformation.All the rows
are passed witout any aggregation.
| Is This Answer Correct ? | 8 Yes | 54 No |
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
how to join the two flatfiles using the joiner t/r if there is no matching port?
How many ways a relational source definition can be updated and what are they?
waht is dataware house
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
What is the difference between a repository server and a powerhouse?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
What are the types of maping in Getting Started Wizard?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to delete duplicate row using informatica?
How to recover the standalone session?
Teradata 
