Answer / mithilesh kumar rai

There r 9 types of files informatica server generating.
1. BadFiles
2. Cache
3. ExtProc
4. LkpFiles
5. SessLogs
6. SrcFiles
7. Temp
8. TgtFiles
9. WorkFlowLogs

Answer / ravi kumar

Output Files are 11

Session Details/logs:
Workflow Log:
Performance Detail File:
Reject Files:
SessLogs
Row Error Logs:
Recovery Tables Files:
Control File:
Email:
Target or Output File:
Cache Files:

Where is metadata stored?

0 Answers  

---

design of staging area?

0 Answers  

---

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

---

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

---

what is parameter file?

1 Answers   Cap Gemini,

---

Why we use lookup transformations?

1 Answers  

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---