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

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---

Explain the pipeline partition with real time example?

0 Answers   Informatica,

---

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

---

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,

---

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

Where is metadata stored?

0 Answers  

---

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

---

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

---

EXL informatica Questions

0 Answers  

---