Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sai krishna karri
Active transformation is a transformation which may or may
not output the same number of rows as the number of rows it
got as the input.
Ex: Aggregator - It will filter the duplicates based on the
group by ports. But, it doesn't mean that it has to filter
the input rows everytime. If it gets the distinct set of
group by values in all the input rows, it will output all
the input rows. So, in this case it cannot filter any row
and the number of input rows and output rows will be
exactly same.
Sorter - Sorter will be basically used to arrange the
incoming records for easier processing(for example, an
aggregator need not read all the rows to find a maximum
value of a sales, if u sort by sales ascending and group by
sales in the connecting aggregator from the above sorter).
In the above case, it will not filter any rows but it will
just rearrange the order of rows as u specify the specific
port(sales) to arrange on.
On the other hand, the sorter transformation is also
provided to output only the distinct rows, where it can
filter the duplicate rows and send the unique set. Here, it
has to filter the duplicates, which in turn changes the row
count i.e input vs Output no. of rows.
If u take a filter, it doesn't have to filter the rows all
the time just because it is name as 'FILTER', it will just
apply the filter condition on all the input rows and pass
those records that qualify the condition. If u set a 'TRUE'
condition in the filter it will pass all the rows as it
gets from the input.
so, based on my above scenarios, i would like to reiterate
that an active transformation is provided with the ability
to filter the rows from the input based on that particular
criteria. It never will be compulsory to change the input
and output number of rows.
Hope my little effort of this answer helped atleast few of
you.
If you have any other questions, just email me at
karrisaikrishna@johndeere.com
| Is This Answer Correct ? | 26 Yes | 6 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
Explain the tuning lookup transformation - informatica
Informatica settings are available in which file?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is joiner change?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How can we store previous session logs?
Differences between version 7.x and 8.x.
What is the difference between router and filter?
What is different between the data warehouse and data mart?
How to implement security measures using repository manager?
What are connected or unconnected transformations?
What is the way to execute pl/sql script using informatica mapping?
What are active and passive transformations?
What is meant by incremental aggregation?
