Answer / vali

to improve the session performance we use the session
partitioning.it improves performance by giving multiple
connections to the source and target.

there are five types of partitioning the session
pass through
data base
round robin
key range
hash partitioning..

Answer / g. manthiramoorthy

Partition Types:
1.Database partitioning.
2.Hash auto-keys.
3.Hash user keys.
4.Key range.
5.Pass-through
6.Round-robin.

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

---

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

---

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

---

What are the transformations that are not supported in mapplet?

0 Answers  

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

---

State the differences between sql override and lookup override?

0 Answers  

---

Explain in detail scd type 2 through mapping.

0 Answers  

---