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
- 33730 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
What differs when we choose the sorted input for aggregator transformation?
tell me about your project functionality
What is the difference between Active and Passive transformation?
How to create or import flat file definition in to the warehouse designer?
How can you increase the performance in joiner transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is meant by LDAP users?
What are the popular informatica products?
What are the prerequisite tasks to achieve the session partition?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Define mapping and session?
How to do unit testing in informatica? How to load data in informatica ?
What is dimensional table?
How does the aggregator transformation handle null values?
explain about unit testing? in real time?
