Answer Posted / nagaraju bhatraju
when we use concurrent process to load when session
fails ...all other session will run normally and load the
data..the failed session will considered as a standalone
sesion ...and we have perform recovery for the failed
session.
there three type where we can recover a failed session
1.start the session again if the Informatica server doesnt
perform the commit
2.else perform recovery on the session
3. if we can recover the session truncacte the data from
target table and run the session.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the restrictions of union transformation?
What are the data movement modes in informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is a grid in Informatica?
What the difference is between a database, a data warehouse and a data mart?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the tasks that can be performed using sq?
State the limitations where we cannot use joiner in the mapping pipeline?
Separate from an archive server and a powerhouse?
What are some examples of informatica etl programs?
What is the meaning of decode in informatica?
What are the measure objects?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?