Answer / chandrababu.sarupuru

Partition's can be done on both relational and flat files.

Informatica supports following partitions

1.Database partitioning

2.RoundRobin

3.Pass-through

4.Hash-Key partitioning

5.Key Range partitioning

All these are applicable for relational targets.For flat
file only database partitioning is not applicable.

Informatica supports Nway partitioning.U can just specify
the name of the target file and create the partitions rest
will be taken care by informatica session.

What are the types of lookup?

3 Answers   Wipro,

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

what is the difference between onsite & client site?

1 Answers  

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

---

What is junk dimention?

3 Answers   Patni,

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---