If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / 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 |
Post New Answer View All Answers
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain the aggregator transformation?
What is event and what are the tasks related to it?
draw informatica architecture 8.6 ?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is lookup change?
Which transformation is needed while using the Cobol sources as source definitions?
What do you understand by a term domain?
What are the performance considerations when working with aggregator transformation?
What is the sequence generator transformation in informatica?
How many ways are there to create ports?
Why update strategy and union transformations are active? Explain with examples.
What are batches?
what is size of u r database?
Explain scd type 3 through mapping.