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

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

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

---

How to generate sequence numbers?

0 Answers  

---

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

What is synonym?

2 Answers   Patni,

---

what is DSS?

3 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

what is the size of your data warehousing?

0 Answers   IBM,

---

Global and Local shortcuts. Advantages.

0 Answers  

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

Explain sessions?

0 Answers  

---