Interested to Buy Any Domain ? << Click Here >> for more details...
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
- 1 Answers
- 1545 Views
- I also Faced
- E-Mail Answers
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
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Explain the features of connected and unconnected lookup.
What is sorter transformation?
What is deployment group?
Mention a few design and development best practices for informatica?
What are some examples of informatica etl programs?
How do you promote a non-reusable transformation to reusable transformation?
What is fact table? Explain the different kinds of facts.
What's the layout of parameter file (what does a parameter file contain?)?
What is substr in informatica?
Explain pmcmd command usage in informatica
What is aggregator transformation in informatica?
What is workflow? What are the components of the workflow manager?
COM components can be used in Informatica
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
