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 if the source is a flat-file?

0 Answers  

---

How to delete duplicate record in Informatica?

7 Answers  

---

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

---

Briefly define a session task?

0 Answers  

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

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

4 Answers   Wipro,

---

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

---

How do you implement scheduling in Informatica?

1 Answers  

---

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

Quickly characterize reusable change?

0 Answers  

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

---