Interested to Buy Any Domain ? << Click Here >> for more details...
how the server recognises , if the session fails after
loading the
100 records in to the target
- 2 Answers
- 10321 Views
- TCS, I also Faced
- E-Mail Answers
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 is informatica?
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
What is a command that used to run a batch?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
What is option by which we can run all the sessions in a batch simultaneously?
What are the mapings that we use for slowly changing dimension table?
Whats there in global repository
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
What is difference between partioning of relatonal target and partitioning of file targets?
what are the types of Data warehousing ?
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
Teradata 
