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
- 34634 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 |
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
what is correlated query?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
Why we use lookup transformations?
What is the reusable transformation?
how many data models u have done in informatica project?
how to use incremental load?
Is stop and abort are same in informatica?
What is the sequence generator transformation in informatica?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
Teradata 
