Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal & bulk loading? and
which one is recommended ? why?
- 2 Answers
- 6852 Views
- I also Faced
- E-Mail Answers
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
how do u set partition points in the mapping?
what is Forward,Reverse and Re_engineering?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Can anyone explain me a scenario from banking and finance...more precisely a mapping
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)
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What is meant by incremental load?
what is the difference between cubes and package in cognos
where are the log files generally stored.Can you change the path of the file.what can the path be?
When do we analyze the tables? How do we do it?
Define Dynamic push down optmization?
what is the use of server?
what are the reporting tools and difference between them?
what is the difference steps for data modeling?
