If the records doesnt satisfy the filter condition where
will it go?
Answers were Sorted based on User's Feedback
Answer / damodharam
The records are rejected.
|Is This Answer Correct ?||11 Yes||7 No|
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.
|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|
Answer / g.bhaskar
The rejected records will go to 'logfile"
|Is This Answer Correct ?||2 Yes||11 No|
Answer / uday
the rejected file will go to rejectwd log files
|Is This Answer Correct ?||2 Yes||13 No|
How to merge First Name & Last Name?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
What are the designer tools for creating transformations?
Why do you use Mapping Parameter and mapping variable?
when we use dynamic lookup,if condition matches what will be the o/p?
How can you increase the performance in joiner transformation?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
If I have a index defined on target table and if set it to bulk load will it work ?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve