If the records doesnt satisfy the filter condition where
will it go?
- 10 Answers
- 12809 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankit kansal
The filtered records will not be written into reject file. Only when data consistency erros or some parsing error occurs, then the records will be move to reject file. In your case PRODUCT_COST value 12 will be filtered out from the mapping flow.
http://deepinopensource.blogspot.com/
| Is This Answer Correct ? | 0 Yes | 0 No |
If the Filter codition doesn't match those records are sent to Bad files. you can check the Bad File in infromatica server directory i.e., C:Informatica10.1.0serverinfa_sharedBadFiles
and the filename is targetFilesname with extention .out
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / praveen
When Ever u apply ur condition it will receive only required condition records.It will not remain others means it will not store in any where.
| Is This Answer Correct ? | 7 Yes | 8 No |
Answer / sara
If the records doesnt satisfy the filter condition. Those
records does not stored anywhere.
| Is This Answer Correct ? | 5 Yes | 6 No |
Answer / venky
if the records doesnot satisfied the filter condition,that
will not pass,it will stop at the filter transformation,it
will not store at anywhere
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / subhransu
The Very Simple Answer "The Records are Rejected". They dont store anywhere.
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / basava
If the records does not satisfy the filter condition then
those records will be stored in $pmbadfile location in
informatica. This is the default path provided by
informatica, you can override this path in session properties.
| Is This Answer Correct ? | 2 Yes | 7 No |
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Under what condition selecting sorted input in aggregator may fail the session?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
Plz can any one say me how to get the informatica certification materials and dumps
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
What is meant by lookup transformation? Explain the types of lookup transformation?
How do you implement configuration management in Informatica?
Diff b/w ShortCut and reusabel Object ?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is Session and Batches?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
Teradata 
