If we are using an aggregator but forget to mention the
group by port .what will be the output??
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 |
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
what are the row and column separations in Flat Files
What is the capacity of power cube?
Do you have knowledge in ralph kimball methodology
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
Define filter transformation?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What is decode in static cache?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
What is mapplet and a reusable transformation?
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
How to differentiate between the active and passive transformations?