Answer / kishore

Mainly  errors were like null values first we need to process error records into one target and good record into another target by using router transformation.after execution of mapping we check the error file size through unix if error file size is greater than 0 then we will send email to source system team with error file attachments. 

What is meant by query override?

0 Answers  

---

What happens if we dont select data driven option?

2 Answers   Zensar,

---

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

What is the cumulative sum and moving sum?

0 Answers  

---

What is the reusable transformation?

0 Answers  

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

how do u tune queries?

1 Answers  

---

in performance wise union is past,union all is past

2 Answers  

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

what is surrogate id ?

3 Answers   IBM,

---