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


Please Help Members By Posting Answers For Below Questions

What is a standalone command task?

643


how many types of dimensions are available in informatica?

553


What is domain and gateway node?

685


What are the tasks that source qualifier perform?

625


What is main use of mapplet?

650






wat are deployement groups in informatica, how it will be used for developers

1244


What is a filter transformation?

559


What is the scenario which compels informatica server to reject files?

597


Slowly changing dimensions, types and where will you use them

1264


What is the meaning of up gradation of repository?

1381


In how many ways we can create ports?

695


What is session task and command task?

639


What is pmcmd command?

664


How to delete duplicate row using informatica?

597


Explain direct and indirect flat file loading (source file type) - informatica

815