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...


what is the difference between normal & bulk loading? and
which one is recommended ? why?

Answers were Sorted based on User's Feedback



what is the difference between normal & bulk loading? and which one is recommended ? why?..

Answer / murthy

normalloding:
this is the optin which we to set in the session under
mapping tab.this will represents the loading of data into
target.this is slower when compared to bulk load.this can
load the data even if u have constraints built on u r
target.this will create the session logs

bulloading
it is the faster loading method.we can' load if u have
constraint defined.this will not create sesion logs

generally normal loading is preffered

Is This Answer Correct ?    7 Yes 2 No

what is the difference between normal & bulk loading? and which one is recommended ? why?..

Answer / prasanna

Session log is always created in any mode you load. The
loading method is no way realted to creation of a session
log.

Normal mode: Will check for constraints while loading. Its
a process which happens record by record.

Bulk mode: This will not check for any constraints on DB.
So, generally when you don;t have any indexes or
constraints defined on your target table, you can use Bulk
mode which is faster.
In Informatica 8.6.1 , if you define bulk mode also.. if
your task need to perform Normal mode operation,
informatica will chabge it to Normal mode automatically run
time.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More ETL Interview Questions

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

0 Answers  


architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

1 Answers   IBM, Infosys,


how many maximum session supports to multiload in teradata ??

0 Answers   IBM,


1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,


we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

3 Answers  


what are the concerns of OLTP and DSS systems?

0 Answers   TCS,


what is SMP AND MPP?

8 Answers  


what is the meaning of upgradation of Repository?

0 Answers   IBM,


Explain etl?

0 Answers  


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  


Explain do we need an etl tool? When do we go for the tools in the market?

0 Answers  


How to Check the source record count from traget table.

5 Answers   IBM,


Categories