what is the difference between filter and router transmissions
Answers were Sorted based on User's Feedback
Answer / lakshmi
A Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. However, a Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions to a default output group.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kiran
in filter,it is not possible to take exception date,but it is possible in router.one condition is possible in filter but in router more no. of columns are possible.
| Is This Answer Correct ? | 3 Yes | 0 No |
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Explain BYNET.
Why do you get spool space errors? How do trouble-shoot them?
Explain some differences between mpp and smp?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
How many types of index are present in teradata?
Explain and compare pros and cons of start schemas?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
How do you define Teradata?
how do you handle ET and UV errors ?
What is meant by a Channel Driver?
What is the function of parser component in teradata?