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 |
What is the difference between correlated sub queries and inner queries?
What are differences between teradata and ansi session modes in teradata?
teradata support to automatically increase the character length or not?
I want to write one query How to get Matched records and unmatched records in table?
where we can use the delimiter in mload? pls let me know
How do you design aggregate tables using teradata?
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
Why MLOAD needs Work Tables?
How is MLOAD Teradata Server restarted after execution?
How can we load single row of data into teradata database. please give me the process.
How many codd's rules are satisfied by teradata database?
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance