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
Which files are created during the session rums by informatics server?
What is olap (on-line analytical processing?
What are the different options available for update strategy?
How identifying bottlenecks in various components of informatica and resolving them?
What are the designer tools for creating transformations?
draw informatica architecture 8.6 ?
What is DR strategy for Informatica project?
What is the sequence generator transformation in informatica?
What is resilience time?
How to extract sap data using informatica?
How does a rank transform differ from aggregator transform functions max and min?
complex mapping ur project u r invlve can u explain and give real time example give me ?
tell me the rules and responsblites in our project(my project is development)
How can you validate all mappings in the repository simultaneously?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?