1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / raghu

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

what is threshold error in informatica?

1 Answers   TCS, Wipro,

Without source how to insert record to target?

6 Answers  

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,




I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

Explain the difference between mapping parameter and mapping variable?

0 Answers  

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

For more Informatica Interview Questions Click Here
Categories