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.

what are the limitation of sorter transformation?

2 Answers   TCS,

---

i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  

---

Can you access a repository created in previous version of Informatica?

1 Answers  

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---

How are indexes created after completing the load process?

0 Answers  

---

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

---

what is correlated query?

2 Answers   IBM,

---

What are the Differences between static cache and dynamic cache?

1 Answers  

---

Why update strategy and union transformations are active? Explain with examples.

0 Answers  

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

---