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 |
Explain the difference between mapping parameter and mapping variable?
what are the types of facts with Examples?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
explain about unit testing? in real time?
How can we use mapping variables in informatica? Where do we use them?
What is operational data source (ODS)?
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
When do you use mapping parameters? (In which transformations)
What are the different lookup cache(s)?
how can we load starting with 11th record of a table from source to target
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?