Answer / rayudu

The number of errors at which the integration service stops the session .The value which we will give to stop the session
is called error threshold value

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  

---

What is degenerated dimention table?

7 Answers   Patni,

---

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

---

WHat all joins are there in Source Qualifier?

1 Answers  

---

What are the different components of powercenter?

0 Answers  

---

How can repository reports be accessed without sql or other transformations?

0 Answers  

---

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

2 Answers   L&T,

---

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,

---

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

---

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---