What is the Difference between sorter and aggregator?

2 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,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

What are variable ports and list two situations when they can be used?

1 Answers  

---

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

---

What are the different clients of powercenter?

0 Answers  

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

what is filelist concept in informatica

4 Answers  

---

what is session parameters?

1 Answers   Cap Gemini,

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

what is materialized view?

2 Answers  

---