surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

major difference between normal loading and bulk loading?

6 Answers  

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

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,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

---

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

What is a filter transformation?

0 Answers  

---

Where is metadata stored?

0 Answers  

---