what are the limitations for bulk loading in informatica for
all kind of databases and transformations?
Answers were Sorted based on User's Feedback
Answer / sujana
v need to disable constraints while performing bulk loading
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / sunil
Bulk load is used for external loaders and in bulk load we
will not write information to datalog file so if any
recovery is needed it is not possible
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / vikas
1.update strategy
2.no constraints on target
3.target should be relational database
4.less number of records
| Is This Answer Correct ? | 2 Yes | 0 No |
What is a command that used to run a batch?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the tasks that can be performed using sq?
Separate from an archive server and a powerhouse?
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
why we use materialized view over view?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
How to enter same record twice in the target table,explain?
What is native users?
When the informatica server marks that a batch is failed?
What is a snowflake schema?