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
- 11717 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
What is a grid in Informatica?
Differentiate between source qualifier and filter transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the differences between oltp and olap?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is enterprise data warehousing?
Differentiate between a database and data warehouse?
In development project what is the process to follow for an etl developer from day1
Explain what is informatica metadata and where is it stored?
What is a snowflake schema?
Can we create multiple integration service on single repository?
Enlist the various types of transformations.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is a filter transformation?
What is a code page?
