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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Briefly define reusable transformation?
Enterprise data warehouse your projects phase by phase explain?
What is a surrogate key?
what is song in infrmatica...?
How do you update the records with or without using update strategy?
What are the various types of transformation?
Explain constraint based loading in informatica
Define pmcmd command?
What is persistent lookup cache?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Repository user profiles
What is data movement mode in Informatica and difference between them?
How to delete duplicate row using informatica?
