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 surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

What is the need of building a data warehouse?

2 Answers  

---

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,

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

---

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

How to jion 2 tables, without using any condition?

11 Answers   Amazon,

---

what is the function of 'F10' informatica ?

4 Answers   IBM,

---

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

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,

---

Can u generate reports in Informatica?

0 Answers   Informatica,

---