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
- 11818 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
Explain the mapping variable usage example in informatica
What is a filter transformation and why it is an active one?
Why do you use Mapping Parameter and mapping variable?
How many ways are there to do 'remove duplicate records in informatica'?
What is a repository? And how to add it in an informatica client?
what is Active lock explain
Enlist some properties of sessions.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Which are the different editions of informatica powercenter that are available?
Write the advantages of partitioning a session?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
wat are deployement groups in informatica, how it will be used for developers
How to Create a folder using pmrep command?
What are Dimensional table?
