What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
Answer / 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 |
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
what is unit testing?tell me proceedure
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
How to load time dimension?
What are the types of caches in lookup? Explain them.
What are the different lookup cache(s)?
what is mapping parameter?
What is the Difference between sorter and aggregator?
how to insert header after each group.
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
What if the source is a flat-file?