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
can u any challenge your project?
Where is metadata stored?
what is SDLC way of code development?
How can repository reports be accessed without sql or other transformations?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are different types of transformations available in informatica?
COM components can be used in Informatica
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to configure mapping in informatica?
can we override a native sql query within informatica? Where do we do it?
What is meant by target load plan?
What do you mean by enterprise data warehousing?
How to use procedural logic inside infromatica?
How do you promote a non-reusable transformation to reusable transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?