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

in what type of scenario bulk loading and normal loading we use?

Question Posted / mehul.thakur

Answers were Sorted based on User's Feedback



in what type of scenario bulk loading and normal loading we use?..

Answer / venkateshmalneni

We use bulk loading in such senarious where there is bulk amount of data is to be loaded into target.
ie we when we want yo load large amount of data fast into the target we use bulk loading.
when u dont want to do the session recovery and u r target should not contain any primary keys
we use normal loading in such senarious when u want to do session recovery.It looks about the constrain based
loding

Is This Answer Correct ?    3 Yes 0 No

in what type of scenario bulk loading and normal loading we use?..

Answer / amol palekar

main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data can not be recovered. But in normal load since the log is created the lost data can be recovered.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

can we see default group,when we use router?if yes how?

2 Answers   L&T,

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

How can we use mapping variables in informatica?

0 Answers  

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

Difference between Target-based loading and constraint-based loading?

0 Answers  

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

For more Informatica Interview Questions Click Here
Categories