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
What are pre and post-session shell commands?
What is workflow manager?
Explain sessions and how many types of sessions are there?
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
Explain load alternative records / rows into multiple targets - informatica
what is $$$$?
Differentiate between a database and data warehouse?
Performance tuning in UNIX for informatica mappings?
Under what condition selecting sorted input in aggregator may fail the session?
What is the use of source qualifier?
What do think which one is the better joiner or look up?
How to delete duplicate row using informatica?
What is the fact table?
Explain sessions. Explain how batches are used to combine executions?
What is InformaticaPowerCenter?
