Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
- 2 Answers
- 14744 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Can you copy the session to a different folder or repository?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
in performance wise union is past,union all is past
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
How to do unit testing in informatica? How to load data in informatica ?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
What aer the out put files that the informatica server creates during the session running?
what is the exact meaning of domain?
without using rank transformation how can we rank items by using some other transformations
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Teradata 
