Answer / bhanu pratap

Hash partitioning:-
use hash partitioning , when we want the power center server
to distribute rows to the partitions by groups.

Eg :- we need to sort items by item ID , but we don't know
how many many items have a particular ID mamber

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

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

4 Answers   Syntel,

---

What are the reusable transformations?

0 Answers   Informatica,

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---

Difference between Data and Index Caches?

0 Answers   Informatica,

---

What will be the approach?

0 Answers  

---

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

How to enter same record twice in the target table,explain?

7 Answers  

---

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

---

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---