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
How many types of transformations supported by sorted input?
how do u identify the changed records in operational data?
Explain different types of partitioning?
what is data modeling?
if i have a query as flat file how can we load data to target table
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What do you understand by the term ‘transformation’?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what are the reports developed in sap bw project and what is the requirement for developing it?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is the difference between cardinality and Nullability?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
dimension object created in oracle can be imported in designer?how?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
what is the use of server manager?