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 is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

what is session override?

2 Answers   Cap Gemini,

---

Mention a few design and development best practices for informatica?

0 Answers  

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

How do you migrate data from one environment to another?

0 Answers  

---

What is metadata reporter?

1 Answers   Informatica,

---

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

---