If the records doesnt satisfy the filter condition where
will it go?
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 |
Explain the features of connected and unconnected lookup.
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
Does an informatica transformation support only aggregate expressions?
Do you have knowledge in ralph kimball methodology
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What are the Advantages of de normalized data?
What does command task mean?
What is blocking transformation?
Two different admin users created for repository are ______ and_______
Insert else update option in which situation we will use
can we use self join in informaitca?
How can we use batches?