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
- 34163 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 |
What are the different threads in DTM process?
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What is a sequence generator transformation?
task is running successfully but data is not loded why?
What is confirmed dimension and fact?
how to obtain performance data for individual transformations.
How to partition the Session?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
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.
why we use stored procedure transformation?
What are the guidelines to be followed while using union transformation?
Teradata 
