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

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,

---

Tell me about MD5 functions in informatica

0 Answers  

---

How mapping parameter and variable works

1 Answers  

---

how to we create datamart?

2 Answers   HSBC,

---

What do you understand by term role-playing dimension?

0 Answers  

---

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,

---

In a sequential batch can you run the session if previous session fails?

4 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

What is the functionality of update strategy?

2 Answers  

---

Define maping and sessions?

3 Answers  

---