Interested to Buy Any Domain ? << Click Here >> for more details...
How to recover sessions in concurrent batches?
- 3 Answers
- 15750 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 |
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
What are the types of lookup?
How do you remove duplicate records in informatica? And how many ways are there to do it?
need for registering a repository server
Flat file heaving 1 lack records and I want to push 52000 records to the target?
What are the join types in joiner transformation?
what is bridge tables in informatica
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Can informatica load heterogeneous targets from heterogeneous sources?
Differentiate between sessions and batches?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
comonly how meny mappings r there in Banking projects?
Teradata 
