Answer / pooja

In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key. Use hash partitioning when you want the Informatica Server to distribute rows to the partitions by group

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,

---

how did u understand business requirement?

2 Answers   TCS,

---

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

---

Which kind of index is preferred in DWH?

2 Answers  

---

Tell me about informatica architecture.

2 Answers   TCS,

---

how to duplicates from expression transformation without using sorter before that

1 Answers  

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

what are the perameter and variable?

3 Answers   IBM,

---

What is the use of incremental aggregation?

2 Answers  

---

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

---

What is power play plug in?

2 Answers  

---