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.

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

How can you validate all mappings in the repository simultaneously?

0 Answers  

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

---

Global and Local shortcuts. Advantages.

0 Answers  

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

what is the difference between mapplet & stored procedure?

1 Answers  

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---

how many session run unix environment what command using ?

1 Answers   HCL,

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---