If the records doesnt satisfy the filter condition where
will it go?




Answers were Sorted based on User's Feedback



If the records doesnt satisfy the filter condition where will it go?..

Answer / damodharam

The records are rejected.

Is This Answer Correct ?    11 Yes 7 No

If the records doesnt satisfy the filter condition where will it go?..

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 records doesnt satisfy the filter condition where will it go?..

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




If the records doesnt satisfy the filter condition where will it go?..

Answer / sara

If the records doesnt satisfy the filter condition. Those
records does not stored anywhere.

Is This Answer Correct ?    5 Yes 6 No

If the records doesnt satisfy the filter condition where will it go?..

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

If the records doesnt satisfy the filter condition where will it go?..

Answer / subhransu

The Very Simple Answer "The Records are Rejected". They dont store anywhere.

Is This Answer Correct ?    1 Yes 3 No

If the records doesnt satisfy the filter condition where will it go?..

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

If the records doesnt satisfy the filter condition where will it go?..

Answer / g.bhaskar

The rejected records will go to 'logfile"

Is This Answer Correct ?    2 Yes 11 No

If the records doesnt satisfy the filter condition where will it go?..

Answer / uday

the rejected file will go to rejectwd log files

Is This Answer Correct ?    2 Yes 13 No

Post New Answer



More Informatica Interview Questions

How to merge First Name & Last Name?

8 Answers  


CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  


What are the designer tools for creating transformations?

0 Answers   Informatica,


Why do you use Mapping Parameter and mapping variable?

0 Answers  


when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,






How can you increase the performance in joiner transformation?

0 Answers  


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?

2 Answers  


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))

4 Answers   Cap Gemini,


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

2 Answers   Accenture,


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.

5 Answers   Amdocs,


If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,


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

15 Answers   TCS,






Categories