The session property on the indexed table can be set to bulk insert mode.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- In bulk mode of loading we cannot use indexes
- Is global temporary table session specific?
- A Table can have unlimited indexes.
- We can store session state in SQL server also.
- When an update strategy is used in the mapping, by default________option is selected in the session properties
- Select the which entry we have to made in treat source as option in session properties if we want map to ha...
- For bulk insert, inserted rows are buffered and sent to the database server
- Using INSERT command only ONE record can be inserted during each execution.