Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

if the session fails after 100 records agian we have to
starts the
session or we go for recovery session

Question Posted / raghu

Answers were Sorted based on User's Feedback



if the session fails after 100 records agian we have to starts the session or we go for recovery ..

Answer / guest

informatcia server has 3 methods to recovering the
sessions.
1)Run the session again if the Informatica Server has not
issued a commit.
2)Truncate the target tables and run the session again if
the session is not recoverable.
3)Consider performing recovery if the Informatica Server
has issued at least one commit.
Use performing recovery to load the records from where the
session fails.

Is This Answer Correct ?    10 Yes 0 No

if the session fails after 100 records agian we have to starts the session or we go for recovery ..

Answer / rekha

U CAN GO FOR PERFORMACE RECOVERT ,IF THE SERVER PERFORMS
ATLEAST ONE COMMIT

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Informatica Interview Questions

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

In session log thier should not be a single error how will u do

3 Answers   HCL,

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

why we use source qualifier transformation?

16 Answers   Accenture,

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

COM components can be used in Informatica

0 Answers  

How to do the error handling of if ur source is flatfiles?

0 Answers  

What is the session task and command task?

0 Answers  

For more Informatica Interview Questions Click Here
Categories