Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bharat kalra
In informatica ..bulk insert or bulk load does 2 things :-
1) Ignores the commit interval specified at the session
level.
2) Do not create a database session log file.
So, advantage is it's very fast as no entry goes into log.
Disadvantage is session cannot be rolled back as no entry
exists in the log file .
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Explain conformed fact?
Database in use is oracle?
Where the data cube technology is used?
Explain how to get the first 100 rows from the flat file into the target?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What is a data profile?
Explain what are the basic needs to join two sources in a source qualifier?
How can you set the session management?
Explain can report net connect multiple datasource at a time in report creation time?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Can you pass sql queries in filter transformation?
Which are the olap tools available that are supported by oracle?
How can we schedule the graph in unix?
What do you mean by static and local variable?
Describe the differences between a data warehouse and data mart.
