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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the types of caches in lookup?
What are the components of the workflow manager?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Could you explain what is enterprise data warehouse?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain the tuning lookup transformation - informatica
What is the meaning of up gradation of repository?
What is a sorter transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
explain abt ur project architecture?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Separate from a database, an information bazaar, and an information stockroom?
What could be the possible resons of locks by user?