Answer Posted / jang
If we what to test for multiple conditons, then we need to
have multiple Filters TRN's, so each filter TRN scans the
data. Where as in Router TRN data is only once scan or read
to evaluate the conditions, so the performance may be good
with router.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
How many ways are there to do 'remove duplicate records in informatica'?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Define the various join types of joiner transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Why is sorter an active transformation?
Why sorter is an active transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How many ways are there to create ports?
What is blocking transformation?
What is the sql query overwrite in source qualifier in informatica
What is meant by lookup transformation?
How to create a non-reusable instance of reusable transformations?
Target increases every day even though no new record was inserted