Interested to Buy Any Domain ? << Click Here >> for more details...
If the records doesnt satisfy the filter condition where
will it go?
- 10 Answers
- 16330 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 |
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
EXL informatica Questions
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
what is mapping parameter?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
Filter transformation in the condition one of the data is NULL would the record be dropped.
What are the data movement modes in informatica?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
Different sorts of metadata that stores in the storage facility?
WAT IS TEXT LOAD?
Teradata 
