What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
Answer Posted / 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 View All Answers
Define pmcmd command?
what is the difference between informatica6.1 and infomatica7.1
What are the restrictions of union transformation?
How many ways are there to do 'remove duplicate records in informatica'?
What is option by which we can run all the sessions in a batch simultaneously?
Define sessions in informatica etl?
What is a stored procedure transformation?
What is pmcmd command?
What do you mean by channel change?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Is it possible to create multiple domains on a single Informatica server?
What is the need of an ETL tool?
What is a connected transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Differentiate between sessions and batches?