Explain about Recovering sessions?
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.
Is This Answer Correct ? | 1 Yes | 1 No |
Repository user profiles
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
Can you use one mapping to populate two tables in different schemas
What is up date strategy and what are the options for update strategy?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
What is main use of mapplet?
What are the different types of schemas?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
What is rank transform?
How to improve the session performance in informatica?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata