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



how the server recognises , if the session fails after loading the 100 records in to the target ..

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

how the server recognises , if the session fails after loading the 100 records in to the target ..

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

Post New Answer

More Informatica Interview Questions

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  


if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,


What is a configuration management?

1 Answers  


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,


What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,






How can you define user defied event?

0 Answers  


Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  


Does Facttable Normalized or Denormalized?

2 Answers   IBM,


In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  


What is a mapplet/worklet in informatica?

0 Answers  


tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  


Categories