how the server recognises , if the session fails after
loading the
100 records in to the target
Answers were Sorted based on User's Feedback
Answer / harikrishna
Based on commit intervel session commits those many records
into target.suppose if commit intervel is 1000 if session
fails after 100 records it won't insert not a single record
into target.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / bsgsr
i cudnt xactly u?s ur question. server recognising in the
sense if the session failed in between and u configured the
session to enable recovery it uses database logging and
finds out the rowid of the record last commited to the
target and loads from the next record. i am sorry if i am
wrong.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are reusable transformations in how many ways we can create them?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
What is depict expression change?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
how to get flatfile containg 10 records half records one target another half another target
Explain sessions. Explain how batches are used to combine executions?
what is the process we used in joiner transformation,there is no matching column in sources?
list out all the transformations which use cache?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
What is a unit Testing?
What are the different clients of powercenter?