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 is the function of look up transformation?
How can you increase the performance in joiner transformation?
What is joiner change?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what is size of u r database?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is intricate mapping?
Can informatica load heterogeneous targets from heterogeneous sources?
What is a predefined event?
What are the differences between oltp and olap?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to use pmcmd utility command?
Quickly characterize reusable change?
what is the hint? how to use it to reduce the query processing in program?
As union transformation gives UNION ALL output, how you will get the UNION output?