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
Differentiate between a database and data warehouse?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
State the limitations where we cannot use joiner in the mapping pipeline?
How to create the source and target database connections in server manager?
What are the different clients of powercenter?
How many types of sessions are there in informatica.please explain them?
Global and Local shortcuts. Advantages.
Explain why we use partitioning the session in informatica?
What are the restrictions of union transformation?
Can you use flat files in Mapplets.
How to go to the older version for a mapping?
What is the use of target designer?
Which files are created during the session rums by informatics server?
Define Pmrep command?
What is meant by lookup transformation? Explain the types of lookup transformation?