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:

Explain target update override in informatica

0 Answers   Informatica,

---

What are the different types of transformation available in informatica.

0 Answers  

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

What is a candidate key?

7 Answers   CTS,

---

What is decode in informatica?

0 Answers  

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

What is the difference between a repository server and a powerhouse?

0 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---