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) Alternative to update strategy transformation

2) out of 1000 records after loading 200 records, the
session got failed. how do u load the rest of records ??

3) use of lookup override

Answers were Sorted based on User's Feedback



1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records..

Answer / raju4dw

U CAN GO FOR SESSION RECOVERY

THEN IT WILL LOADS ONLY REMAING RECORDS INSTEAD OF ALL
RECORDS.



RAJENDRA

Is This Answer Correct ?    7 Yes 0 No

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records..

Answer / mike

1)YOu can update the target table by using target update
override. I think this might be the alternative

2)consider performance recovery

3)lookup override is nothing but overriding the default sql
which is generated by the lookup at run time. the default
sql contains select,groupby and orderby clauses. The
orderby clause orders the data based on the ports in lookup
tab. If you want to change the order then we need to
mention two hyphens at the end of the sql, which means the
query generated by the informatica server is commented.

correct me if i was wrong

Is This Answer Correct ?    6 Yes 0 No

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records..

Answer / pradeep

1)Alternative to updated strategy,we can with target update override. US works based primaray key constrainst where as target updated override works without primary key constraints.

2)When you configure session with Normal load,the integration service performs record by record as a result IS can capture commit points and it enables the session recovery.

The IS capture commits points from database log and saves in repository

3) The lookup transformation genrates the sql qurey,query contains select,group by,order by.we can override default query by specifying the order by clause

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  


create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,


WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


What did you do in source pre load stored procedure

1 Answers  


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,


What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,


Explain the different lookup methods used in informatica?

0 Answers  


what is dynamic cashe

3 Answers   Informatica,


how to convert the .doc docs into .txt format using informatica

4 Answers  


Define filter transformation?

0 Answers  


when we dont use aggregator in mapping ?

2 Answers   CSC,


Categories