What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
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 |
Sequence generator, when you move from develoment to production how will you reset
How to load last 10 records of flat file in to the target?
what is confirmed fact?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
Which one is better performance wise connected/un-connected lkp?why?
Is there any model difference between ODS and DWH
How mapping parameter and variable works
what are cost based and rule based approaches and what is the difference?
What is active and passive transformation?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
Describe data concatenation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?