Answer / rayudu

Non-Fatal_Errors are the errors that doesnot force the session to stop when it encounters errors .

Fatal Errors are the errors that occurs when the connections to source ,targets and to the database is failed .

Rgds,
rayudu

Answer / anusha n

Fatal error occurs when integration service unable to fetch source, target or repository. when session encounters fatal error, integration service terminates session.

Non fatal occurs records to be dropped from ETL Process. It doesn't force session to stop.

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

What do you mean by filter transformation?

0 Answers  

---

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

What are the new features of informatica 9.x developer?

0 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  

---

What are the different threads in DTM process?

1 Answers  

---

How we can confirm all mappings in the repository simultaneously?

1 Answers  

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---