GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing
Go To First  |  Previous Question  |  Next Question 
 Data Warehousing  |  Question 26 of 87    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  
opbang 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  
VVM.SP 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


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape