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 |
in realtime which situations u can use unconnected lookup transformation
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
When the informatica server marks that a batch is failed?
What is meant by lookup transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
How to create Target definition for flat files?
Write the prerequisite tasks to achieve the session partition?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?