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
- 11819 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 informatica powercenter repository?
In real time scenario where can we use mapping parameters and variables?
As union transformation gives UNION ALL output, how you will get the UNION output?
Which means the first record should come as last record and last record should come as first record and load into the target file?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
What is dynamic cache?
Where is the cache stored in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
Can we create a Integration service without a Repository service and vice versa?
why u go for dimensions ?
what is the architecture of any Data warehousing project?
Teradata 
