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
- 11716 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What are the types of presistent cache in look up tr.
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
How to merge First Name & Last Name?
who is the best faculty for informatica in hyderabad ameerpet?
what is lookup ?
Performance tuning( what you did in performance tuning)
we have to use order by,where,having we to implement sql query
What is the difference between bitmap and btree index?
Why you use repository connectivity?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
How to load only the first and last record of a flat file into the target?
What is the difference between a router and a filter transformation?
Teradata 
