My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---

What is deployment group?

0 Answers  

---

From where we can start or use pmcmd?

3 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

How will the document be delivered to me?

0 Answers  

---

What is parallel processing in informatica?

0 Answers  

---

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---

What is a joiner transformation and why it is an active one?

0 Answers  

---