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
- 11688 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 is the drillup & drill down?and use of the drill up and drill down?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
How is union transformation utilized?
How to prepared lld.can any one tell me detailed explanetion.
Differentiate between router and filter transformation?
can you use flat file for lookup table?why?
What are some examples of informatica etl programs?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the use of target designer?
What is a standalone command task?
Why do you use Mapping Parameter and mapping variable?
How will you combine 3 different sources with a single source?
Teradata 
