Under what condition selecting sorted input in aggregator may fail the session?
- 1 Answers
- 1220 Views
- I also Faced
- E-Mail Answers
Answer / Amit Kumar Verma
Selecting sorted input in an aggregator may fail the session if the input contains duplicate values for a group that is being aggregated and the aggregate function used does not support duplicate values, such as SUM or COUNT(DISTINCT). In this case, an error will occur because the aggregator cannot determine which value to use when summing or counting duplicates.
| Is This Answer Correct ? | 0 Yes | 0 No |
How many repositories can be created in informatica?
What is meant by incremental aggregation?
normalizer transformation
how remove 1st 3 records & last 3 records in informatics
how do u tune queries?
What are the differences between source qualifier and joiner transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are Target Options on the Servers?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
Explain the different dimensions.
What is main use of mapplet?
Teradata 
