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
Explain target update override in informatica
Write the unconnected lookup syntax?
What is primary and backup node?
How to convert multiple rows to single row (multiple columns) in informatica
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to use procedural logic inside infromatica?
What are the different transaction levels available in transaction control transformation?
can u give example for factless fact table
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
update strategy transformation in informatica
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 are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to generate sequence numbers without using the sequence generator transformation?
What is the way to execute pl/sql script using informatica mapping?
Explain the types of transformations?