Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

What are conformed dimensions?

1 Answers  

---

How to delete duplicate row using informatica?

0 Answers  

---

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

---

Which transformation should we use to normalize the COBOL and relational sources?

4 Answers   DELL, IBM, Lehman Brothers,

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

What is a difference between complete, stop and abort?

0 Answers  

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

What is informatica? Why do we need it?

0 Answers  

---