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:

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  

---

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

What is the target load order?

3 Answers   HCL, Informatica,

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

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,

---

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

---

What happens if we dont select data driven option?

2 Answers   Zensar,

---