What is data merging, data cleansing and sampling?

6 Answers   Satyam,

---

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

---

Can you access a repository created in previous version of Informatica?

1 Answers  

---

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

How to update records in Target, without using Update Strategy?

3 Answers  

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

What is staging area?

11 Answers  

---

What is router transformation

4 Answers   CSC,

---