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 / naresh_infa96

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

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

Clarify the utilization of aggregator cache record?

0 Answers  


write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,


What is status code?

2 Answers  


How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,






Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,


Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  


Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,


i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,


can we use mapplet as starting n ending object in mapping

2 Answers   TCS,


What are the measure objects?

0 Answers  


Categories