Answer / swetha

If you stop a session or if an error causes a session to
stop, refer to the session and error logs to determine the
cause of failure. Correct the errors, and then complete the
session. The method you use to complete the session depends
on the properties of the mapping, session, and Informatica
Server configuration.

Use one of the following methods to complete the session:

Run the session again if the Informatica Server has not
issued a commit.

Truncate the target tables and run the session again if the
session is not recoverable.

Consider performing recovery if the Informatica Server has
issued at least one commit.

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

What is IQD file?

1 Answers  

---

What is expression transformation?

0 Answers  

---

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,

---

What is staging area?

11 Answers  

---

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

what is the difference between mapplet & stored procedure?

1 Answers  

---

What is the need for an etl tool?

0 Answers  

---

What are the limitations of joiner transformation?

0 Answers   Informatica,

---