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

Could you explain what is enterprise data warehouse?

0 Answers  

---

What is a code page?

0 Answers  

---

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

---

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

---

Explain the etl program with few examples.

0 Answers  

---

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

Explain the types of lookup transformation?

0 Answers  

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

tell me the push down optimization

2 Answers   Wipro,

---

waht is dataware house

2 Answers  

---

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

---