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.

How can repository reports be accessed without sql or other transformations?

0 Answers  

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

---

Explain grouped cross tab?

1 Answers   Accenture,

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

---

According to his methodology what all you need before you build a datawarehouse

0 Answers  

---

In development project what is the process to follow for an etl developer from day1

0 Answers  

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

how do u move the code from development to production?

6 Answers  

---