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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between project backlog and product backlog?

1237


what is the difference steps for data modeling?

1766


What are materialized views & where do we use them?

676


Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1809


Two default user groups created in the repository are____and_____.

1804






HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1806


What is Data Vault???

2494


how would u estimate the size of Aggregator transform data and index cache?

1705


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

961


What are the three tiers in etl?

771


Difference between flat files and relational sources?

1973


When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

698


How many types of transformations supported by sorted input?

879


what is pmrep command?

2120


What is etl tool in hadoop?

656