can i call router is a passive transformation
Answers were Sorted based on User's Feedback
Answer / sailendra
Router transformation is active transformation as it divide
your source into a particular no. of groups and each group
is mapped to a different target.As the no. of rows get
changed so it's a active transformation.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jyoti
yes,
if set the group condition yes , it means it cant filtering the records and pass all the record to target or any other transformation
so in this situation router is act as a passive transformation
Is This Answer Correct ? | 1 Yes | 1 No |
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
How would you load a very large file in teradata in general?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
What is dimensional modeling?
how can we analyze the locks ?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
How to Extract data from multiple legacy systems?
What is meant by a Virtual Disk?
what are the file sizes in your project?
Does SDLC changes when you use Teradata instead of Oracle?
Define views in teradata with syntax.