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 |
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
What is enterprise data warehousing?
Under which circumstances, informatica server creates reject files?
What is a command that used to run a batch?
tell me the rules and responsblites in our project(my project is development)
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
what is confirmed fact?
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
what is mean by grouping of condition column in lookup transformation?
What is the use of source qualifier?