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

Showing Answers 1 - 3 of 3 Answers

opbang

  • Sep 23rd, 2006
 

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. 

  Was this answer useful?  Yes

Sravan gopisetty

  • Sep 24th, 2006
 

The rows which does not meet the condition they rejected.

  Was this answer useful?  Yes

PFD

  • Nov 6th, 2006
 

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.

  Was this answer useful?  Yes

lakshmi

  • Dec 5th, 2006
 

Hi,

Exactly to where do the rejected rows go? Is there any thing in Informatica like a trash as in windows?

  Was this answer useful?  Yes

herbert

  • Dec 9th, 2006
 

yes there is  folder or file in informatica which collects this rejected rows, its location is given while installing the s/w

  Was this answer useful?  Yes

VVM.SP

  • Mar 18th, 2008
 

In Filter Transformation Those row are not meet to the filter condition they are rejected.  These rejected rows are appear in $PMBad.Dir

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions