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

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,


What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  


in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,


In which scenario did u used Mapping variable?

0 Answers   Cognizant,


What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,






explain different levels in pushdown optimization with example?

2 Answers   TCS,


write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,


How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,


Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  


What is confirmed dimension and fact?

7 Answers  


What are the new features of the server manager in the informatica 5.0?

1 Answers  


What is the Hierarchy of DWH?

1 Answers  






Categories