Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
- 2 Answers
- 14712 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ajay pareek
first of all bad files and reject file both are same, there is no difference between them.
we call them reject fils that havving .bad extension.
there are not any files with .reject extension.
so the bad files or reject file keep the rejected records.
correct me if i am wrong
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
TELL ME ABOUT WORK FLOW SCHEDULING?
What is InformaticaPowerCenter?
Why do you use Mapping Parameter and mapping variable?
What are the types of data that passes between informatica server and stored procedure?
How to eliminate 1st and last rows from the source and load the inbetween rows.
What are the types of lookup transformation?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
what is shortcut in informatica? difference between shortcut,reusable object?
Teradata 
