explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
Answer Posted / rajkumar bachu
1)Bulkload & Narmal load
Normal: In this case server manager allocates the
resources(Buffers) as per the parameter settings. It creates
the log files in database.
Bulk: In this case server manager allocates maximum
resources(Buffers) available irrespective of the parameter
settings. It will not create any log files in database.
In first case data loading process will be time taking
process but other applications are not affected. While in
bulk data loading will be much faster but other application
are affected.
Is This Answer Correct ? | 12 Yes | 13 No |
Post New Answer View All Answers
Explain the difference between a data warehouse and a data mart?
What is the use of source qualifier?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the differences between oltp and olap?
Explain dynamic target flat file name generation in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is informatica? Why do we need it?
What are mapplets?
How would you copy the content of one repository to another repository?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Scheduling properties,whats the default (sequential)
What is a sorter transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How many dimensions are there in informatica?