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. 

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

---

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

What are the static cache and dynamic cache in informatica?

0 Answers  

---

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 Answers   Deloitte,

---

what is the flat file partition and where have to specify it

1 Answers   TCS,

---

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

---

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---