What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
Answer Posted / abhinaw prakash
Bad File stores data which does not pass through business
standard.
Reject file has data which does not pass through business logic.
EX:
EmpID Ename Sal
10 Abhi 10000
20 Ram 3000
30 Cp 7000
40 Rohit
Now if we apply Filter condition as Sal>5000,Then
Bad file will have records
40 Rohit
(Emp cannot have NO SALARY column)
Reject File will have record
20 Ram 3000
| Is This Answer Correct ? | 6 Yes | 11 No |
Post New Answer View All Answers
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is the difference between source qualifier transformations source filter to filter transformation?
What is complex mapping?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is Session and Batches?
How to join three sources using joiner?
What are data-driven sessions?
What is a code page?
tell me about your project functionality
Explain the mapping variable usage example in informatica
Define filter transformation?
can we override a native sql query within informatica? How do we do it?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to go to the older version for a mapping?
What is meant by lookup transformation?