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
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
what is the use of server?
what is session partitioning?
flat filevalidation in informatica
Can u access a repository created in previous version of Informatica?
what are the data modeling tools you have used?(polaris)
Define slowly changing dimensions (SCD)?
what is data modeling?
Give the benefits of data integration suite?
what is the use of structures?how many nodes can u create in a structure?
what are the reports developed in sap bw project and what is the requirement for developing it?
Explain the difference between etl tool and olap tools?
What are the ETL Testing Operations?