Interested to Buy Any Domain ? << Click Here >> for more details...
What is active and passive transformation?
- 10 Answers
- 41057 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sasikumar_bes
A transformation is said to be active when the no. of input
rows to the transformation is not equal to the number of
output rows from the transformation.
input rows != output rows either it can be less or more
when input rows is equal to the output rows then it is
called passive transformation.
| Is This Answer Correct ? | 43 Yes | 11 No |
Answer / atiric softwares(raja)
An active transformation can change the no. of rows that
passes through it eg: filter transformation passes the rows
from the source to target that which meet the filter condition.
an passive transformation cannot change the rows that which
passes through it eg: an expression transformation that
performs the calculation on the data and passes all the rows
from source to target
| Is This Answer Correct ? | 25 Yes | 2 No |
Answer / 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 |
Answer / sameer
In Sorter, there is an option as "Allow only distinct",
which can change the no.of output records. So it is
classified as Active.
| Is This Answer Correct ? | 20 Yes | 4 No |
Answer / thava
I totally agree with Sai Krishna Karri that any
transformation
can be active or passive depends to the condition we
provided.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / malli
Active is a no of rows can change pass through it, and
Passive is can not change the no of rows pass through it.
eg: filter transformation passes the rows
from the source to target that which meet the filter condition.
eg: an expression transformation that
performs the calculation on the data and passes all the rows
from source to target
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / chandu
Hello All,
I have a query to all of u guys...
U all said If any t/r changes the number of records it is a
active ritee....?
So here my query is about Union t/r, In Informatica by
default Union t/r acts as Union all means allow duplicates..
If I have 2 sources having 20 records each after union t/r
the result should be 40 records so, there is no change in
records, even then it is an active t/r yyyyyyyy?
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / mayank jhawar
Active Transformation -
An Active transformation can change teh number of rows that
pass through it from source to traget. It eliminates rows
that do not meet the condition in transformation.
Passive Transformation -A Passive transformation does not
change teh number of rows that pass through it i.e., it
passes all rows through the transformation.
List of transformations coming under Active transformations
are -
Source Qualifier Transformation
Aggregator Transformation
Filter Transformation
Rank Transformation
Joiner Transformation
Router Transformation
Normalizer Transformation
Update strategy Transformation
Sorter Transformation
ERP Source Qualifier Transformation
Advanced External Procedure Transformation
Look Up (now it is an active transformation)
And here find the Passive Transformations list -
Expression Transformation
Sequence Generatoe Transformation
LookUP Transformation (till Informatica Version9.0)
Stored Procedure Transformation
XML Source Qualifier Transformation
External procedure Transformation
Input Transformation(Mapplet)
Output Transformation(Mapplet)
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / mln
Active transformations number of output rows will be lesser
than input rows.
and active transformations work at column level.
| Is This Answer Correct ? | 17 Yes | 18 No |
Answer / baiju
When a row enters a transformation, informatica assigns a
rownumber. if this number change for a row, that's an
Active transformation. In other words the nth row comming
IN will go as n'th row, then the transformation is PASSIVE.
Sorter is an active transformation!! IT never changes
the total row count, it changes only the order!!
| Is This Answer Correct ? | 15 Yes | 19 No |
what is datamart
What are the different types of Type2 dimension maping?
In a sequential batch can u run the session if previous session fails?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
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 to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
what is the -ve test case in your project.
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
Write the prerequisite tasks to achieve the session partition?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Separate from a database, an information bazaar, and an information stockroom?
Teradata 
