Answer / Kishan Kumar Bera

Rejected data in Informatica can be stored in a separate table or file, depending on the setup. To extract the rejected data, you can create a custom error handling transformation and route the errors to a different destination (like a file or a table).

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

What is rank index in rank transformation?

1 Answers  

---

what are the Methods For Creating Reusable Transformations?

1 Answers   Informatica,

---

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

What are the basic needs to join two sources in a source qualifier?

3 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

---

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

---