Why we use stored procedure transformation?

4 Answers  

---

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  

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

---

need for registering a repository server

1 Answers  

---

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

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,

---

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

Explain sessions?

0 Answers  

---