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
How will the document be delivered to me?
What do you mean by blocking transformation?
How is union transformation utilized?
In which transformation you cannot drag ports into it?
How to partition the Session?
what is INFORMATICA TESTING process
Where do we use mapping variables in informatica?
Differentiate between a database and data warehouse?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Enlist few areas or real-time situations where informatica is required.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
design of staging area?
What is pmcmd command?
Mention few power centre client applications with their basic purpose?
How do you manage the Parameter files while migrating your data from one environment to another environment?