Interested to Buy Any Domain ? << Click Here >> for more details...
Source Qualifier is an active t/r but there is no change of
row count then y should we called it active t/r & Router ,
sorter some times no change in row count then Y we called
its active t/r?
- 2 Answers
- 11609 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravindra
A transformation is active does not mean that it always
change number of rows. An active transformation can have
passibility to change the number of rows.
In Source Qualifier we can do SQL-override to limit the
number of rows in whare condition, Sorter can remove the
duplicates when select the property checkbox Distinct, In
Router you can only extract the records from selected
(filtered) group. So the number of rows can be impacted.
Expression is an example for passive transformation. Never
change number of rows.
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
Can we override a native sql query within informatica?
What do you mean by filter transformation?
What is the format of informatica objects in a repository?
What is workflow? What are the components of the workflow manager?
What are connected or unconnected transformations?
How to load last n records of file into target table - informatica
Which is the t/r that builts only single cache memory?
Explain lookup transformation in informatica
What is meant by LDAP users?
How are indexes created after completing the load process?
tell me the rules and responsblites in our project(my project is development)
What are the restrictions of union transformation?
What are the various types of transformation?
In informatics server which files are created during the session rums?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
