Answer Detail: RE: Suppose your filtering the rows using a filter tra...

GeekInterview.com > Interview Questions > Data Warehousing

Print |

Question: Suppose your filtering the rows using a filter transformation only the rows meet the condition pass to the target .

Tell me where the rows will go that doesnot meet the condition.

Thanks in advance

November 11, 2006 00:18:12	#3
PFD	Member Since: Visitor Total Comments: N/A
RE: Suppose your filtering the rows using a filter tra...
The rows which do not meet the condition are rejected. In case u want to use keep those rows which do not meet he condition, then use a Router Transformation specifying 2 conditions(true as well as false) and route them to 2 different targets.

Back To Question