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

September 09, 2006 02:54:22	#1
OM PRAKASH BANG	Microsoft Expert Member Since: March 2006 Total Comments: 46
RE: Suppose your filtering the rows using a filter tra...
Informatica filter transformation default value is 1 i.e. True. If you place a break point on filter transformation and run the mapping in a debugger mode, you will find these values 1 or 0 for each row passing through filter. If you change 0 to 1, the particular row will be passed to next stage.

Back To Question