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 different types of transformation available in informatica.

0 Answers  

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,

---

What is polling in informatica ?

1 Answers   TCS,

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

how do u move the code from development to production?

6 Answers  

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

What is mapplet and a reusable transformation?

2 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---