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.

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

What are the new features of informatica 7.1?

2 Answers  

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

What is meant by active and passive transformation?

0 Answers  

---

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

---