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
- 34614 Views
- Nomura, TCS, I also Faced
- E-Mail Answers
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
Explian the Process of deployment groups in informatica
Explain the difference between mapping parameter and mapping variable?
Can we create a Integration service without a Repository service and vice versa?
What is a passive transformation?
How can you validate all mappings in the repository simultaneously?
Is there any target staging area in informatica not staging area
What is primary and backup node?
How many ways are there to create ports?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the function of union transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the different versions of informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
What is informatica worklet?
What are batches?
