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



What is the difference between Bad file and Reject file? and Where u can see the Reject file? What r..

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

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What r..

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

Post New Answer

More Informatica Interview Questions

What is the difference between stop and abort in informatica

0 Answers   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?

12 Answers  


Differentiate between a repository server and a powerhouse?

0 Answers  


What is the difference between a router and a filter transformation?

1 Answers   TCS,






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

0 Answers   TCS,


can we override a native sql query within informatica? Where do we do it?

0 Answers  


How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  


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..

4 Answers   Wipro,


How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,


What are the Advantages of de normalized data?

3 Answers  


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


Categories