Interested to Buy Any Domain ? << Click Here >> for more details...
All active transformations r passive or not?
- 7 Answers
- 11599 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
every transformation is passive by default since they dont
have any default condition. they become active only when a
condition is added.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / chow
In my view all t/rs r passive.Depending upon the using t/rs
u can say it is passive or not.For ex what kalyani saying
about filter t/r(it is a active).ok
Suppose i have a source with 10 records in 10th
department.And i give a condition in filter as deptno=10.In
this situation filter recieve 10 records and passes 10
records.
In this situation filter is active?
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vishnu
My answer would be like in the case of filter t/r if the c ondition is not mentioned then the default condition is true i.e., all the records from the source r moved to the target in this situation filter t/r acts as passive.
suppose in aggregator t/r if we r not mentioned any group by port then last record will be displayed in this situation it acts as active.So not all active t/rs are passive
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kalyani
An active transformation can change number of rows that
pass through it, such as a
filter transformation that removes rows that do not meet
the filter condition
A passive transformation does not change the number of
rows that pass through it,
such as Expresion transformation that performs a
calculation on data and passes all rows
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / ganesh prasad
no
all active transformations r not a passive transformation
active transformation will change the no of rows at target
level.
but passive transformations cont change the no of rows at
target level
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / saradhi
no all the active transformations are not passive even
though its give same no of records in source.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / prasanthi
yes if a conditon is applied to a tranformation then only
we can say whether the no of rows will be change or not so
i say that all active tranformations are defaultly passive
| Is This Answer Correct ? | 0 Yes | 2 No |
To provide support for Mainframes source data,which files r used as a COBOL files
what is mapping parameter and mapping variables
What is confirmed dimension with scenario
what is a time dimension? give an example?
What is Cognos script editor?
what is size of u r database?
What are the new features of informatica 7.1?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
What are the join types in joiner transformation?
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.
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
How/where can i install Informatica software with oracle or teradata as database
Teradata 
