What is the difference between Normal load and Bulk load?
Answer Posted / sachin
1.It is also not allow the constraint when we make Target load type as Bulk Mode
2.Also we do not allow to use indexes on database level in Bulk mode But in Normal mode we can allow indexes as well as constraint.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is unit testing?tell me proceedure
How to improve the performance of a session using sorter transformation?
how many types of dimensions are available in informatica?
What is exclusive and normal mode for repository services?
What is the use of code page?
What is a connected transformation?
How are indexes created after completing the load process?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is dimensional table?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What do you understand by SOA of Informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is pmcmd command?
Mention few power centre client applications with their basic purpose?