if the session fails after 100 records agian we have to
starts the
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
sessions.
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
session fails.
| Is This Answer Correct ? | 10 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 |
which is better perfomancewise lookup or joiner and why?can anyone give example?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
What are the types of maping wizards that r to be provided in Informatica?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Write the prerequisite tasks to achieve the session partition?
What are the ETL tools available in DWH?
Types of error logs in Informatica?
Define mapplet?
What are the issues you have faced in your project? How did you overcome those issues?
What is query panel?