Data Warehousing - Suppose your filtering the rows using a filter transformation only the rows meet the condition pass

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Interview Questions > Data Warehousing

Go To First | Previous Question | Next Question

Data Warehousing | Question 26 of 98

Print

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

Total Answers and Comments: 6

Last Update: March 18, 2008 Asked by: Dharma

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 23, 2006 02:54:22

#1

Member Since: March 2006 Contribution: 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.

Is this answer useful? Yes | No

September 24, 2006 11:10:04

#2

Sravan gopisetty

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

The rows which does not meet the condition they rejected.

Is this answer useful? Yes | No

November 06, 2006 00:18:12

#3

PFD

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.

Is this answer useful? Yes | No

December 05, 2006 18:47:45

#4

lakshmi

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

Hi

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

Is this answer useful? Yes | No

December 09, 2006 01:13:19

#5

herbert

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

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

Is this answer useful? Yes | No

March 18, 2008 03:20:21

#6

Member Since: March 2008 Contribution: 7

RE: 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

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

Is this answer useful? Yes | No

Sponsored Links

Sponsored Links

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved