How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

---

What is joiner cache?

2 Answers   TCS,

---

What is meant by pre and post session shell command?

0 Answers  

---

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

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,

---

How can we delete duplicate rows from flat files?

0 Answers  

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

What are Dimensional table?

0 Answers   Informatica,

---

what is diff between grep and find

3 Answers   IBM, iFlex,

---

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

---