what is the difference between normal & bulk loading? and
which one is recommended ? why?
Answer Posted / 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 View All Answers
What is a lookup table in etl?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Explain etl?
how would u estimate the size of Aggregator transform data and index cache?
Which transformation we use to convert 'NA' to 'Not Available'
what is the difference steps for data modeling?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what are the concerns of OLTP and DSS systems?
what is dynamic insert?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
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)
Compare ETL & Manual development?
what is pmrep command?
Two default user groups created in the repository are____and_____.