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 the reusable transformations?
Is it possible to revert a global repository to local one and why?
Tell me about MD5 functions in informatica
How to create or import flat file definition in to the warehouse designer?
What is an expression transformation in informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain lookup transformation is active in informatica
Explain scd type 3 through mapping.
What is the cumulative sum and moving sum?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain what are the different versions of informatica?
Differentiate between sessions and batches?
What is data caches/ index caches?
define galaxy repository in informatica
differences between service based and product based?
