Interested to Buy Any Domain ? << Click Here >> for more details...
How to recover sessions in concurrent batches?
- 3 Answers
- 15604 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
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 ? | 4 Yes | 0 No |
Answer / aswin
Its purely depending on the way the design involved..Recovery strategy is not possible with flatfile targets..If commit happens inbetween, there is no point in running session from beginning
so manual intervention is required to restat the flatfile target load fails
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / seshagiri k
by removing the target table and run the session again
if it is wrong pls send the answer to my mail
| Is This Answer Correct ? | 0 Yes | 0 No |
How to use procedural logic inside infromatica?
Can you create a flatfile target
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
What is the way to execute pl/sql script using informatica mapping?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
what is update strategy transformation ?
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
What is DR strategy for Informatica project?
why union transformation is active transformation?
When we are using Dynamic Cache,which options we will select in session level?
what is constraint based loading
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Teradata 
