What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
Answer Posted / ysindhureddy77@gmail.com
If we do not use an input port in group-by neither in aggregate expression, the Integration Service
will return only the last row value of the column for the input rows.
For example, if we have 100 rows coming from source then aggregator will output only the last record (100th
record)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are data-driven sessions?
Clarify the aggregator change?
What is the difference between informatica 7.0 and 8.0?
How many numbers of sessions can one group in batches?
How do you take back up of repository?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are Dimensional table?
What could be the possible resons of locks by user?
What is informatica worklet?
define galaxy repository in informatica
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the types of presistent cache in look up tr.
What is expression transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What does refresh system mean, and what are its distinctive choice?