If the records doesnt satisfy the filter condition where
will it go?
- 10 Answers
- 12917 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 |
Filter transformation in the condition one of the data is NULL would the record be dropped.
What do you mean by filter transformation?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Can we create a node as a gateway node and the same node can be assigned to a grid?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
How to eliminate duplicates in FF and oracle both
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
one source to target loading insert new rows and update existing rows?
Teradata 
