if the session fails after 100 records agian we have to
session or we go for recovery session
Answers were Sorted based on User's Feedback
Answer / guest
informatcia server has 3 methods to recovering the
1)Run the session again if the Informatica Server has not
issued a commit.
2)Truncate the target tables and run the session again if
the session is not recoverable.
3)Consider performing recovery if the Informatica Server
has issued at least one commit.
Use performing recovery to load the records from where the
|Is This Answer Correct ?||9 Yes||0 No|
Answer / rekha
U CAN GO FOR PERFORMACE RECOVERT ,IF THE SERVER PERFORMS
ATLEAST ONE COMMIT
|Is This Answer Correct ?||2 Yes||1 No|
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build , 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user  and connection string . (6016|1292) Service stopped.
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Explain sql transformation in script mode examples in informatica
What are roles and groups and benefits of using them?
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
what is the function of 'F10' informatica ?
What is workflow monitor?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
What is option by which we can run all the sessions in a batch simultaneously?
HOW DO YOU CONNECT TO REMOTE SERVER ?
Two Default User groups created in the repository are ____ and ______