Answer / rakesh

Using FileList concept.
i.e; keep all flat file paths in a text file and mention
this file name in source file name of session. and mention
the source file type as INDIRECT.

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

tell me the push down optimization

2 Answers   Wipro,

---

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

What is the difference between view and materialised view?

6 Answers  

---

what is the process of target load planing?

2 Answers   IBM,

---

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

how many data models u have done in informatica project?

2 Answers   TCS,

---