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 |
what is a transforamation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
Explain direct and indirect flat file loading (source file type) - informatica
what is mapping parameter?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
In session log thier should not be a single error how will u do
What is data transformation manager process?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
what are the transformations that restricts the partitioning of sessions?