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 |
What is the difference between stop and abort in informatica
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
How to extract original records at one target & Duplicate records at one target?
Differentiate between a repository server and a powerhouse?
What is the difference between a router and a filter transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
can we override a native sql query within informatica? Where do we do it?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
What are the Advantages of de normalized data?
Normalizer transformation is not involved in Mapplet.. why???