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|
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
In which scenario did u used Mapping variable?
What are the different transaction levels available in transaction control transformation?
explain different levels in pushdown optimization with example?
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
How will you update the first four rows and insert next four rows in a mapping?
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
What is confirmed dimension and fact?
What are the new features of the server manager in the informatica 5.0?
What is the Hierarchy of DWH?